sql日期加自增长编号的实现

--获得最后添加InfoNOdeclare @last_InfoNO nvarchar(12)   declare cur_findlast scroll cursor   for select InfoNO from FeedbackInfos   open cur_findlast   fetch last from cur_findlast     into @last_InfoNO   close cur_findlast   deallocate cur_findlast  --拼接InfoNO  declare @InfoNO nvarchar(12)if(convert(nvarchar(8),getdate(),112)=substring(@last_InfoNO,1,8))beginSet @InfoNO = substring(@last_InfoNO,1,8)+substring(convert(nvarchar(12),convert(int,'1'+substring(@last_InfoNO,9,4))+1),2,4)endelsebeginSet @InfoNO = convert(nvarchar(8),getdate(),112)+'0001'end