SQL数据表插入随机数

在构造测试数据时，我们需要对测试表插入随机数据。如何构造测试数据呢？

declare @T TABLE (id int identity(1,1),[Name] nvarchar(20), Randnum int)insert @T ([Name])select 'A1' union allselect 'A2' union allselect 'A3' union allselect 'A4' union allselect 'A5' union allselect 'A6' union allselect 'A7' union allselect 'A8' union allselect 'A9' union allselect 'A10' union allselect 'A11' union allselect 'A12'select * from @T/*id Name Randnum----------- -------------------- -----------1 A1 NULL2 A2 NULL3 A3 NULL4 A4 NULL5 A5 NULL6 A6 NULL7 A7 NULL8 A8 NULL9 A9 NULL10 A10 NULL11 A11 NULL*/update @Tset Randnum=rand()*1000select * from @T/*id Name Randnum----------- -------------------- -----------1 A1 3572 A2 3573 A3 3574 A4 3575 A5 3576 A6 3577 A7 3578 A8 3579 A9 35710 A10 35711 A11 35712 A12 357*/update @Tset Randnum=(select cast(ceiling(rand(checksum(newid()))*100) as int))select * from @T/*id Name Randnum----------- -------------------- -----------1 A1 282 A2 523 A3 664 A4 35 A5 976 A6 1007 A7 618 A8 659 A9 8210 A10 6211 A11 6812 A12 7*/