SQL, Structured Query Language is a non-procedural language and is used by database engines to interpret SQL queries to create/modify/access the database elements.
T-SQL, Transact-SQL, is a procedural extension to SQL, used by SQL Server. It is similar to PL/SQL of Oracle.
Following are the important difference between SQL and T-SQL.
|1||Type||SQL is non-procedural by nature.||T-SQL is procedural by natue.|
|2||Methods||SQL provides data manipulation and controlling functions.||With T-SQL, we can write own procedures, functions with local variables.|
|3||Proprietary||SQL is open to use and is common across RDBMS softwares.||T-SQL is specific to SQL Server and is proprietary.|
|4||Query order||Multiple querires are submitted one by one.||Using T-SQL, multiple queries can be submitted in batches.|
|5||Features||DDL, DML, DQL operations are provided.||Apart from SQL features, transaction controls, exception handlings etc. are provided.|