Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

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.

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 While there are a great many books ...

A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored ...

SQL SERVER TRIGGERS 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 ...