Microsoft SQL Server 2008 with its release included some new
features that some of us (as developers) will find interesting and useful. In
this article, which will be followed by others, I will try to shed some light
on the row constructer feature (a nifty addition) as attributed to the family
of T-SQL.
About The Feature
Ever spent time to fill a table with T-SQL insert statement
where you have multiple records of the same format to insert into a single
table. Well, row constructors come to the rescue. This feature allows you to effect
multiple insertions of data using a single insert statement.
Requirements
In order to apply the article procedures, you should have
installed any version of Microsoft SQL Server 2008 (Express, Standard,
Developer, or Enterprise).