As you can see, SQL Server 2012 introduces many new and interesting improvements. Many of these functions will be easy to understand for .NET developers since they're borrowed from the .NET Framework.

T-SQL Tips -- GO # and WHILE Loops. Two quick tricks: populating a table with data quickly, and boosting performance with WHILE loops. By Joshua Jones; 07/12/2010 ...

T-SQL Smarts -- Preventing Injection Attacks . Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack.

In SQL Server, a trigger is a special type of stored procedure that is automatically executed in response to certain events occurring in the database. Triggers can be used to enforce business rules, ...