Using Row Constructor, you can insert data easily during manual insertion.
INSERT INTO TblEmployee (EmpID, EmployeeName, Salary)
VALUES (1,'Alwyn',1000),
(2,'Joe',2000),
(3,'Arun',3000)
The above code will insert 3 records at a time,
you can insert any number of records using this new feature in Sql Server 2008
No comments:
Post a Comment