Difference between SQL (Structured Query Language) and T-SQL (Transact-SQL).

SQL

SQL, Structured Query Language is a non-procedural language used by the database engine to interpret SQL queries to Create/Modify/Access Database

T-SQL

T-SQL (Transact-SQL) is a procedural extension of SQL used by SQL Server. Similar to Oracle's PL/SQL.

The following are the important differences between SQL and T-SQL.

##1Type SQL is non-procedural in nature. T-SQL is procedural in nature. 2MethodSQL provides data manipulation and control functions. Using T-SQL, we can write our own procedures and functions with local variables. tr>3ProprietarySQL is open for use and is common in RDBMS software. T-SQL is specific to SQL Server and proprietary. 4Query sequenceSubmit multiple queriesUsing T-SQL, multiple queries can be submitted in batches. 5Function Provides DDL, DML, and DQL operations. In addition to providing SQL functions, transaction control, exception handling, etc.

gentlemen. No.	Key	SQL	T-SQL

The above is the detailed content of Difference between SQL (Structured Query Language) and T-SQL (Transact-SQL).. For more information, please follow other related articles on the PHP Chinese website!