What is Transact-SQL?
SQL Server uses Transact-SQL, a version of the Structured Query Language (SQL), as its database query and programming language. SQL is a set of commands that allows you to specify the information that you want to retrieve or modify. With Transact-SQL, you can access data and query, update, and manage relational database systems.
The American National Standards Institute (ANSI) and the International Standards Organization (ISO) have defined standards for SQL. Transact-SQL supports the latest ANSI SQL standard published in 1992, called ANSI SQL-92, plus many extensions to provide increased functionality