Quick Tip 004 - SQL Row Constructors
Download Source Files: Here Another excellent addition to SQL Server 2008 was the introduction of the row or table constructors. In this quick tip I’m going to illustrate how to use the row constructor inside INSERT and SELECT statements.