Frank Bergdoll. Master T-SQL with Azure: Your Ultimate Guide to Learning SQL Fast! Posted: April 3, 2025 | Last updated: April 3, 2025. Learn how to harness the power of Azure for T-SQL and ...

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.

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 better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL. Stored ...

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 ...

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.