生成随机数

declare @randnum nvarchar(50)
declare @OrderNo NVARCHAR(50)
set @randnum=CONVERT(nvarchar,(select cast( floor(rand()*1000) as int)),11)
SET @OrderNo='1111110'+ @randnum
SELECT @randnum
select @OrderNo