1) SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL

Go insert into table1 (empid,empname)

select 1,'sen'

union all

select 2,'thil'

union all

select 3,'kumar'

union all select 5,'siva'

union all select 6,'senthil'

union all select 5,'siva'

union all select 6,'senthil' select * from table1

go

---------------------------------------------------------------------------------------------------------