News

Microsoft Copilot in SSMS, now in preview, is available as an optional workload when installing SSMS 21, and assists customers in writing, editing, and fixing T-SQL queries using natural language.
Quickstart: Scale compute for dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics using T-SQL Scale compute in dedicated SQL pools using T-SQL and SQL Server Management Studio (SSMS).
A comparison of Transact-SQL and languages supported by Microsoft's Common Language Runtime.
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 ...
05/03/2010 As much as making your T-SQL work smarter for you, a la dynamic SQL, is helpful, it can also introduce a significant about of risk. I'm speaking specifically about SQL injection attacks.
Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.