Populating sample data

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
Published 04 April 2008 14:45 by Madhivanan
Filed under: , ,

Comments

No Comments