Sunday, March 25, 2012

Table row constructor: To insert multiple rows with single insert command

In SQL Server 2008, New feature called Table row constructor used to insert multiple values with a single insert command, Please find below syntax for sql server 2005 and 2008


now using row set constructor we can insert multiple values using single insert command



No comments:

Post a Comment