What is Transact-SQL (T-SQL)?
Transact-SQL (T-SQL) is Microsoft's proprietary version of ANSI SQL for its SQL Server relational database.
Structured Query Language (SQL) is the most widely used relational database query language and its standardized version - designed by the American National Standards Institute (ANSI) - is known as ANSI SQL. However, most vendors also implemented proprietary SQL versions with additional functions.
T-SQL fully supports ANSI SQL and extends the language with various functions, e.g. B. Control of Flow language, local variables and extensions of the UPDATE and DELETE statements.
Examples of flow control language include the following:
BEGIN and END keywords to mark a block of transactions.
WAITFOR to wait for a specific event or time to complete a transaction.
RETURN to return immediately from a stored procedure or function.
T-SQL is critical to SQL Server because every SQL Server database action sends a series of T-SQL statements to the database. Actions carried out are initially translated into T-SQL statements, even when using the graphical user interface.
T-SQL statements can be run in the main access tool for SQL Server and SQL Server Management Studio (SSMS) or in sqlcmd, the dedicated command line tool. This operation is similar to using the MS-DOS environment to run Windows operating system commands.