SQL server insert multiple rows with one statement
Method 1:
declare @tblRegister table(Id int,Name varchar(50),Email varchar(50))
INSERT INTO @tblRegister(Id,Name,Email)
values(1,'Anurag','MCA'),
(2,'Ashish','B.Sc.'),
(3,'Akhilesh','B. Tech')
Select * from @tblRegister
Method 2:
declare @tblRegister table(Id int,Name varchar(50),Email varchar(50))
INSERT INTO @tblRegister(Id,Name,Email)
select 1,'Anurag','MCA'
union all
select 2,'Ashish','B.Sc.'
union all
select 3,'Akhilesh','B. Tech'
Select * from @tblRegister