SQL Server 2005 introduced many new switches and features in T-SQL.  Often times new features are met with “Why would I need to do that?”.  The reality is that the SQL Server development team are not adding features for nothing. One of my favorites is the OUTPUT clause.  The OUTPUT clause can be used in [...]