declare @T TABLE (id int identity(1,1),[Name] nvarchar(20), Randnum int)
insert @T ([Name])
select 'A1' union all
select 'A2' union all
select 'A3' union all
select 'A4' union all
select 'A5' union all
select 'A6' union all
select 'A7' union all
select 'A8' union all
select 'A9' union all
select 'A10' union all
select 'A11' union all
select 'A12'
select * from @T
/*
id Name Randnum
----------- -------------------- -----------
1 A1 NULL
2 A2 NULL
3 A3 NULL
4 A4 NULL
5 A5 NULL
6 A6 NULL
7 A7 NULL
8 A8 NULL
9 A9 NULL
10 A10 NULL
11 A11 NULL
*/
update @T
set Randnum=rand()*1000
select * from @T
/*
id Name Randnum
----------- -------------------- -----------
1 A1 357
2 A2 357
3 A3 357
4 A4 357
5 A5 357
6 A6 357
7 A7 357
8 A8 357
9 A9 357
10 A10 357
11 A11 357
12 A12 357
*/
update @T
set Randnum=(select cast(ceiling(rand(checksum(newid()))*100) as int))
select * from @T
/*
id Name Randnum
----------- -------------------- -----------
1 A1 28
2 A2 52
3 A3 66
4 A4 3
5 A5 97
6 A6 100
7 A7 61
8 A8 65
9 A9 82
10 A10 62
11 A11 68
12 A12 7
*/
