use db1 CREATE Table tblBook ( Id int identity primary key, Author_name nvarchar(50), country nvarchar(50) )
use db1 Declare @Id int Set @Id = 1
While @Id <= 2000000 Begin Insert Into tblBook values ('Author - ' + CAST(@Id as nvarchar(10)), 'Country - ' + CAST(@Id as nvarchar(10)) + ' name') Print @Id Set @Id = @Id + 1 End
This will insert 2000000 rows in table tblBook |