日期:2014-05-18 浏览次数:20715 次
declare @i int set @i=1000 update P_BUSINESS_LIST set ORDERNO='SR'+rtrim(@i),@i=@i+1 ------解决方案--------------------DECLARE @i int; set @i=1000; update P_BUSINESS_LIST set ORDERNO= 'SR '+rtrim(@i),@i=@i+1