Skip to main content

T-SQL

Get more information on using Transact-SQL (T-SQL) to work with SQL Server data.

T-SQL

Get more information on using Transact-SQL (T-SQL) to work with SQL Server data.


  • Accessing and Changing Relational Data Overview
    Find all you need to know about using Transact-SQL with SQL Server, from basics such as connecting to the database to advanced concepts like summarizing data.
  • Transact-SQL Overview
    Get an introduction to the T-SQL language and an entry point into the Transact-SQL reference material.
  • Stored Procedures
    Create and use stored procedures in SQL Server 2000 to improve performance, reduce network traffic, and enhanced security.
  • User-Defined Functions
    Create and use user-defined functions (UDFs) in SQL Server 2000 to extend the set of SQL Server functions to meet your application's specific requirements.
  • Exploring SQL Server User-Defined Functions
    John Papa introduces you to the different types of SQL Server UDFs and provides guidance on where each is useful.
  • Enforcing Business Rules with Triggers
    Create and use triggers in SQL Server 2000 to enforce business rules and protect data integrity.
  • Exploring SQL Server Triggers
    John Papa explores the different trigger types that SQL Server 2000 makes available and discusses how triggers can be implemented to enforce business rules or referential data integrity in database applications.
  • INSTEAD OF Triggers
    Kalen Delaney explains the INSTEAD OF trigger type introduced in SQL Server 2000.
  • Use Triggers to Set Limits
    Tom Moreau leads an exercise in building a trigger to limit the number of detail rows for an order to a maximum of four, providing a great step-by-step analysis of the problem and the T-SQL tweaks that are needed to get it right.