Ars Technica

SQL Server 2005 TSQL syntax for getting dta out of an update or insert

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...
Visual Studio Magazine

4 New T-SQL Functions

SQL Server 2012 was released last April, making it the 11th major release of the product. Every new version has delivered new functionality that should excite developers, and this release is no ...
Redmond Magazine

T-SQL Smarts: Executing Sp_executesql

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...
Ars Technica

[TSQL] UPDATE syntax question

I'm trying to update a column in a temp table, based on a subquery. Brain is blank as to why I can't get the following update to work.<BR><pre class="ip-ubbcode-code ...