select distinct '1234 4567 '+convert(varchar,ID)+' '+convert(varchar,ID)+' '+convert(varchar,ID)+' '+convert(varchar,ID) as 'B' from ( select convert(int,rand(checksum(newid()))*@minNumber) as ID from syscolumns,sysobjects )t
set rowcount 0 ----------------------------------------------------------------------- declare @num1 int ,@num2 int ,@num3 int ,@num4 int set @num1=rand(abs(convert(int,checksum(newid()))))*10000 set @num2=rand(abs(convert(int,checksum(newid()))))*10000 set @num3=rand(abs(convert(int,checksum(newid()))))*10000 set @num4=rand(abs(convert(int,checksum(newid()))))*10000 select convert(varchar(100),@num1)+' '+convert(varchar(100),@num2)+' '+convert(varchar(100),@num3)+' '+convert(varchar(100),@num4) --------------------------------------------------------------------------- declare @r1 numeric (15,0),@r2 numeric (15,0) SELECT @r1=RAND( (DATEPART(mm, GETDATE()) * 100000 ) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) )*10000 print @r1
select nchar(cast(19968+rand()*20902 as int)) /* ---- 手*/
declare @t table(col nvarchar(4)) insert @t select nchar(cast(19968+rand()*20902 as int)) insert @t select nchar(cast(19968+rand()*20902 as int)) insert @t select nchar(cast(19968+rand()*20902 as int)) select * from @t /* col ---- 澄 蝐 巾 */
--所有漢字範圍包括繁體19968到40868 declare @t table(col nvarchar(4)) insert @t select nchar(cast(19968+rand()*40868 as int)) insert @t select nchar(cast(19968+rand()*40868 as int)) insert @t select nchar(cast(19968+rand()*40868 as int)) select * from @t /* col ---- 敒 삷 贵*/
@minNumber int, --随机数最小值
@rows int --要取得的行数
select @maxNumber=10000, @minNumber=10000,
@rows=10
set rowcount @rows
select distinct '1234 4567 '+convert(varchar,ID)+' '+convert(varchar,ID)+' '+convert(varchar,ID)+' '+convert(varchar,ID) as 'B'
from (
select convert(int,rand(checksum(newid()))*@minNumber) as ID
from syscolumns,sysobjects
)t
set rowcount 0
-----------------------------------------------------------------------
declare @num1 int ,@num2 int ,@num3 int ,@num4 int
set @num1=rand(abs(convert(int,checksum(newid()))))*10000
set @num2=rand(abs(convert(int,checksum(newid()))))*10000
set @num3=rand(abs(convert(int,checksum(newid()))))*10000
set @num4=rand(abs(convert(int,checksum(newid()))))*10000
select convert(varchar(100),@num1)+' '+convert(varchar(100),@num2)+' '+convert(varchar(100),@num3)+' '+convert(varchar(100),@num4)
---------------------------------------------------------------------------
declare @r1 numeric (15,0),@r2 numeric (15,0)
SELECT @r1=RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )*10000
print @r1
/*
----
手*/
insert @t select nchar(cast(19968+rand()*20902 as int))
insert @t select nchar(cast(19968+rand()*20902 as int))
insert @t select nchar(cast(19968+rand()*20902 as int))
select * from @t
/*
col
----
澄
蝐
巾
*/
declare @t table(col nvarchar(4))
insert @t select nchar(cast(19968+rand()*40868 as int))
insert @t select nchar(cast(19968+rand()*40868 as int))
insert @t select nchar(cast(19968+rand()*40868 as int))
select * from @t
/*
col
----
敒
삷
贵*/