通过SQL自动添加流水号------ --自动流水号为纯数字的情况，如 201104190005------ declare @x int,@y char(8)select @x= COUNT(no)from TestNo where CAST(DTas date)=CAST(GETDATE()as date)if(@x=0) beginselect @y=convert(char(8),getdate(),112)insert TestNo(No,DT) values( @y+'0001',GETDATE()) endelse insertTestNo(No,DT)values( (selectMAX(No)+1from TestNo where CAST(DTas date)=CAST(GETDATE()as date)),GETDATE()) select * from TestNo ------ --自动流水号为字符的情况，如 WT201104190005------ declare @x1 int,@y1 char(8)select @x1= COUNT(CharNo)from TestNo where CAST(DTas date)=CAST(GETDATE()as date)if(@x1=0) beginselect @y1=convert(char(8),getdate(),112)insert TestNo(CharNo,DT) values('WT'+@y1+'0001',GETDATE()) endelsebegin insertTestNo(CharNo,DT) values('WT'+cast((selectMAX(CAST(SUBSTRING(charno,3,12)as bigint))+1from TestNo where CAST(DTas date)=CAST(GETDATE()as date))asvarchar(50)) ,GETDATE()) endselect * from TestNo --------------------------------------------------------
