SQL Query to generate multiple rows. Session 39

Generating Millions of Rows in SQL Server -create table customer ( id int, name varchar(30), emailid varchar(20), dept varchar(20) ) ------------------------------------------------------------------------------- set nocount on declare @id int declare @name varchar(30) declare @emailid varchar(30) declare @dept varchar(5) ----------------------------------------------------------------------------------- select @id=1 select @dept='HR' while(@id (lessthansign) =100000) begin select @name='abc'+cast(@id as varchar) select @emailid='abc'+cast(@id as varchar)+'@gmail.com' insert into customer values(@id,@name,@emailid,@dept) select @id=@id+1 if(@id%10000=0) print cast(@id as varchar)+'rows inserted' end