------自动获取自增列 如数据已有20090226005,他可以得到下一个值,适合用于那些用来递增的列的值
declare @number varchar(50);
select @number=(case when (max(Convert(bigint,replace(Upper(Ord_Id),'DG',''))+1))>0
then max(Convert(bigint,replace(Upper(Ord_Id),'DG',''))+1)
when (max(Convert(bigint,replace(Upper(Ord_Id),'DG',''))+1))<=0 then
replace(Convert(varchar(20),getdate(),102),'.','')+'001' else replace(Convert(varchar(20),getdate(),102),'.','')+'001' end )
from [Lzj_OrderC] where convert(varchar(50),Ord_CreateDate,102)=convert(varchar(50),getdate(),102);
print @number