One of the Difference between the SQL 2005 AND SQL 2008.
SQL2008 gives you the facility to insert multiple rows in a single statements.
--SQL Server 2005
INSERT dbo.EMPLOYEE(SALARY) VALUES (1000)
INSERT dbo.EMPLOYEE(SALARY) VALUES (2000)
INSERT dbo.EMPLOYEE(SALARY) VALUES (3000)
INSERT dbo.EMPLOYEE(SALARY) VALUES (4000)
--SQL Server 2008
INSERT dbo. EMPLOYEE(SALARY) VALUES (1000),(2000),(3000),(4000)
Thanks
Showing posts with label SQL2005 AND SQL2008. Show all posts
Showing posts with label SQL2005 AND SQL2008. Show all posts
Monday, July 16, 2007
Subscribe to:
Posts (Atom)