A Brief Introduction to Transact-SQL
Transact-SQL is Microsoft’s and Sybase’s proprietary extension to the conventional SQL (structured query language). Transact-SQL is sometimes abbreviated as T-SQL. This enhancement brought procedural programming language functionalities, such as local variables, control-of-flow constructs, and additional functions for various needs.
The purpose of this two-part article is to give a brief overview on the usage of T-SQL. If you are already familiar with any SQL flavor, whether it's MySQL, Oracle, or perhaps SQL-92, that’s a huge benefit. However, throughout this article I will assume that you have at least some knowledge regarding relational databases.
Please Click Here For More