Learning Guide

T-SQL Learning Guide

Transact-SQL (T-SQL) is Microsoft's enhanced version of the Structured Query Language (SQL) that includes transaction control, exception handling, error handling, row processing and more. SQL Server applications must be using T-SQL statements to communicate with the server, but how your T-SQL is written and run can ultimately impact your server performance. This learning guide offers you an introduction to all things T-SQL, from basic definitions to handy stored procedures to best and worst practices.

If you have T-SQL questions not addressed in this learning guide, visit

    Requires Free Membership to View

Ask the SQL Server Expert to pose a question to development guru Greg Low. If you have your own handy stored procedures and T-SQL tricks, e-mail us and we'll post them on SearchSQLServer.com for all your peers to see.

More on T-SQL

Learn T-SQL formatting tricks for SQL Server 2012

Read about T-SQL functions in SQL Server 2012

Find the joy of data values with SQL Server 2012


   T-SQL 101
   T-SQL stored procedures
   T-SQL best and worst practices
   T-SQL in SQL Server 2005
   T-SQL debugging
   T-SQL querying



  T-SQL 101  Return to Table of Contents


This was first published in July 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: