Pages

Friday, November 21, 2008

Multiple Insert in SQL Server

One ofthe v ery good feature of SQL Server 2008 is to insert multiple records at one using single INSERT statements.

INSERT INTO dbo.Departments
VALUES (1, 'Human Resources', 'Maryam'),(2, 'Sales', 'Biju'),
(3, 'Finance', 'Gilly'),(4, 'Purchasing', 'Barbera'),
(5, 'Manufacturing', 'Screwer');

No comments: