Sometimes you may need some sample data for testing purpose The following may help you in generating some sample data of different datatypes
select abs(checksum(newid()))%10000 as intcol, abs(checksum(newid()))*rand()/100 as float_col, dateadd(day,0,abs(checksum(newid()))%100000) as date_col, substring(replace(cast(newid() as varchar(36)),'-',''),1,abs(checksum(newid()))%15) as varchar_col, abs(checksum(newid()))%2 as bit_col from master..spt_values where type='p' and number between 1 and 200
Tags: t-sql, sql_server, sample_data, random_data,