About Transact-SQL

Transact-SQL is an enhanced version of Structured Query Language (SQL) used to perform transactions and operations with relational database systems. With Transact-SQL, you can retrieve data from a database, create databases and database objects, add data, modify existing data, and perform other complex functions. For more information, see the Microsoft SQL Server Transact-SQL Reference within the Microsoft SQL Server Programmer's Toolkit in the MSDN Platform SDK.