select cast(datepart(second,getdate()) as varchar(2)) +cast( month((getdate())) as varchar(2)) +cast(day(getdate()) as varchar(2)) + cast(left(cast((rand()*10000000) as int),6) as varchar(6)) + cast(datepart(hour,getdate()) as varchar(2))+cast(datepart(minute,getdate()) as varchar(2))
SQL随机数
最新推荐文章于 2023-03-19 17:27:07 发布