22,210
社区成员
发帖
与我相关
我的任务
分享
--try
select top 10 *
from tablename tablesample(1000 rows)
order by newid()
set nocount on--75151448行数据
select count(*) from syscolumns a,syscolumns b,syscolumns c
set statistics time on
select
top 10 * from(select a.name as name,left(b.name,10) as name1, checksum(newid()) as hash from syscolumns a,syscolumns b,syscolumns c )t
where
hash%100=0
set statistics time off
set nocount off