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.