Wednesday, February 23, 2011

3 different ways to insert records in SQL Server 2008

insert into EMP (EMPID, FirstName,LastName)
values (11,'amit','kumar')
insert into EMP (EMPID, FirstName,LastName)
values (22, 'ajay','kumar')

OR


insert into EMP (EMPID, FirstName,LastName)
Select 11,'amit','kumar'
UNION
Select 22, 'ajay','kumar'

OR

insert into EMP (EMPID, FirstName,LastName)
values
(11,'amit','kumar'),
(22, 'ajay','kumar')