Start mastering SQL today! #TSQL #Azure #SQLLearning. Frank Bergdoll. Master T-SQL with Azure: Your Ultimate Guide to Learning SQL Fast! Posted: April 3, 2025 | Last updated: July 10, 2025.

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.

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.

Even though the SQL value is a string, SQL Server executes the string as if it is SQL code. Transact SQL, or T-SQL, provides you with the language to create the dynamic code.

This not only clutters T-SQL code, but forces the execution plan to use an index scan. In SQL Server 2022, we have a new IS DISTINCT FROM and IS NOT DISTINCT FROM syntax that not only handles both ...