Friday, December 9, 2016

Create bulk data in database table using SQL

I had a requirement to create a very heavy size database to test some sampling technique. I have created a table in database called "NewEmployee" and written set of Insert statement with dummy data using SQL script. The script is given here:

declare @id int
select @id = 1
while @id >=1 and @id <= 100000
begin
Insert Into NewEmployee Values (17, '18'+ convert(varchar(5), @id), NULL, 14, 'Don' + convert(varchar(5), @id), 'Boscow'+ convert(varchar(5), @id), '2000-07-31', '1976-05-15', 'adventure-works\don'+ convert(varchar(5), @id), 'don'+ convert(varchar(5), @id)+'@dummydata.com', '320-555-0195', 'M', 'Don Boscow'+ convert(varchar(5), @id), '320-555-0195', 0, 'M', 1, 'Production', '2000-07-31', NULL, 'Current');

    select @id = @id + 1
end

No comments:

Post a Comment