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');
Friday, November 21, 2008
Multiple Insert in SQL Server
Labels:
SQL Server,
SQL Server 2008,
SQL Server Tips,
Vijaya Kadiyala
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment