Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

More T-SQL Goodness in SQL Server 2008 (codename katmai)

Back in June I talked about some T-SQL enhancements that are coming our way in SQL Server 2008. One of those things is the ability to define multiple rows in an INSERT statement like so:

insert t1 values (@i),(@i+1);


Very cool stuff.  Some people seem to be naming this feature 'row constructors'.


Well Greg Duncan has been exploring in more detail and has discovered some more very cool things that you can do with row constructors. I don't often write blog posts solely for the purpose of linking to someone else but this is too good to miss. If you have any interest at all in writing T-SQL code then head here and read what Greg has to say.






Published Friday, August 17, 2007 8:33 PM by jamie.thomson



Adam Machanic said:

The name "row constructors" (actually, it should be "row value constructors") comes directly from the ANSI Standard.

August 18, 2007 6:03 PM

Scott Whigham said:

It's about time. I've been tired of writing INSERT Table SELECT 1 UNION ALL SELECT 2 for quite some time...

August 20, 2007 9:12 PM
New Comments to this post are disabled

This Blog


Powered by Community Server (Personal Edition), by Telligent Systems