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

My first blog

This is my first blog and i am very excited about it. I am working as a SQL Server DBA and i have created this blog for my own reference of my posts, i'm glad if it helped others too.