【手游项目5】SqlServer利用 GETDATE 和 cast 生成唯一订单号

declare @CurDate datetime, @SerialNumber varchar(100) set @CurDate=GETDATE();--获取当前时间 select @SerialNumber = Cast( RIGHT( year(@CurDate),4) as varchar) + --年 right('00' + cast(month(@CurDate) as varchar),2) + -- 月 right('00' + cast(day(@CurDate) as varchar),2)+ right('00' + cast(DateName(hour,@CurDate) as varchar),2)+ right('00' + cast(DateName(mi,@CurDate) as varchar),2)+ right('00' + cast(DateName(ss,@CurDate) as varchar),2)+ right('00' + cast(DateName(ms,@CurDate) as varchar),2) set @SerialNumber = @SerialNumber+ cast(@dwUserID as varchar)

用日期+时间+用户id

举个栗子：写入时间 2020-10-07 17:23:39.667  用户id 14231 得到唯一序列号 202010071723396714231