Transact-SQL (T-SQL) is an extension to Structured Query Language (SQL). It is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. This article lists known TechNet articles that are devoted to various aspects of the Transact-SQL language.

SQL Server in General

• T-SQL Useful Links
• Structured Query Language
• How SQL Server Determines Type of the Constant
• SET ANSI_PADDING Setting and Its Importance
• Thinking in Sets
• Database Size Limitations in All Versions and Editions of SQL Server
• Understanding NOLOCK Query Hint
• SQL Server Columnstore Index FAQ
• SQL Server Columnstore Performance Tuning
• Microsoft SQL Server 2012 New Functions
• Structured Error Handling Mechanism in SQL SERVER 2012
• All-at-Once Operations in T-SQL
• Custom Sort in Acyclic Digraph
• Simplified CASE expression
• Error handling within Triggers using T-SQL
• Calling Stored Procedures Using Transact-SQL
• Representing List of Values Using a Single Value
• Transact-SQL: Return DBCC Output in a View
• Same Query on Different SQL Server Versions
• T-SQL: Negative Effects of SSMS Query Designer
• T-SQL: Delete All Rows From a Table Except Top(N) Rows
• T-SQL: How the Order of Elements in the ORDER BY Clause Implemented in the Output Result
• T-SQL: How to Sort a Column that Contains Character-Separated Numbers
• T-SQL: Troubleshooting When a Column Alias that Created in the SELECT Clause Cannot be Used in the ORDER BY Clause
• T-SQL: Table Variable vs Temp Table (Two Reasons for Using Table Variable Instead of Temp Table)
• T-SQL: Check Database Consistency Using Visual Studio SSDT
• T-SQL: Make a Read Copy of Database by Using Synonym, Trigger and SQL Agent Job
• T-SQL: Improve the Performance for LIKE Wildcard by Changing the Collation
• SQLServer Tips: How To Make a Table Read Only in Database

Triggers and Constraint

• INSTEAD OF Triggers
• T-SQL: CHECK Constraints
• T-SQL: Error Handling for CHECK Constraints
• T-SQL: Dynamic Data Masking

• Dynamic Pivot on Multiple Columns
• SQL Server PIVOT
• SQL Server - Display Horizontal Rows Vertically
• T-SQL: Create Report for Last 10 Years of Data
• T-SQL: How to put Grouped Results on the Same Line
• T-SQL: PIVOT Ordered pair Columns

CLR

• RegEx Class
• SQL Server Resource Re-Balancing in Failover Cluster
• SQL Server: Create Random String Using CLR

CTE

• Hierarchical Table Sorting with a Parent-Child Relation

Dates Related

APPLY Operator

• Fixing Missing Data Based on Prior Row Information
• T-SQL: Applying APPLY Operator
• APPLY Operator in SQL Server

String Functions

• Patindex Case Sensitive Search
• T-SQL: How to Find Rows with Bad Characters
• Sort Letters in a Phrase using T-SQL
• T-SQL: Remove Leading and Trailing Zeros
• T-SQL: Create Random String
• CLR: Create Random String
• T-SQL: Split String with a Twist
• T-SQL: RIGHT, LEFT, SUBSTRING and CHARINDEX Functions
• T-SQL: How to Generate Random Passwords

Meta-Data

• T-SQL Script to Get Detailed Information about Index Settings
• How to Check the Syntax of Dynamic SQL Before Execution
• How to Compare Two Tables Definition / Metadata in Different Databases 
• T-SQL Script to Find the Names of the Stored Procedures that Used Dynamic SQL
• How to Generate Index Creation Scripts for all Tables in a Database using T-SQL
• How to Check when Index was Last Rebuilt
• T-SQL: Fast Code for Relationship within the Database
• T-SQL: Table Sizes in SQL Server

XML

• Generate XML with Same Node Names using FOR XML PATH
• Generate XML - Column names with their values as text() enclosed within their column name tag
• Avoid T (space) while generating XML using FOR XML clause
• SQL Server XML: Sorting Data in XML Fragments
• How to Extract Data in XML to Meet the Requirements of a Schema
• T-SQL Tips : Search and Replace String From Multiple Nodes Within a XML Document

Relational Division

• T-SQL: Relational Division

Miscellaneous

• Finding Floor and Fraction of the Decimal Number
• T-SQL: Gaps and Islands Problem
• T-SQL: FIFO Inventory Problem - Cost of Goods Sold
• T-SQL Script to update string NULL with default NULL
• Using TRY_CONVERT in SQL Server 2012
• Crazy TSQL Queries play time
• Convert VBA Code to Transact-SQL
• T-SQL: Get Connectionstring Details from a SSIS Package
• T-SQL: Find the Peak Hour
• Behavioral Difference of IIf Function in T-SQL Compared To SSRS
• Setting Dependencies Between SQLServer Agent Jobs
• T-SQL: SQL Server Agent Job Execution Status

See Also

• T-SQL Useful Links
• TechNet Guru Contributions - Transact SQL
• SQL Server 2012
• SQL Server Developer Resources
• Wiki: Portal of TechNet Wiki Portals
• Free E-Books about SQL and Transact-SQL

Other Languages

• Portal Transact-SQL (pt-BR)