4 ms·To get 100k random rows in T-SQL it's: SELECT TOP (100000) * FROM tblNm ORDER BY newid()by rrrrrrrrrrrryan 4y agoTo get 100k random rows in T-SQL it's: SELECT TOP (100000) * FROM tblNm ORDER BY newid()