产生5位数的若干随机数

 create table table3
(ID int identity(10000,1),
num int
)

declare @id int
set @id=1
set nocount on
while @id<201
begin
set nocount on
insert table3 (num)values(1)
set @id=@id+1
set nocount off
end
set nocount off

select count(*) from table3
select id,newid() as guid from table3 order by guid