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:
Post a Comment