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.

##1 Type SQL is non-procedural in nature. T-SQL is procedural in nature. 2 Method SQL provides data manipulation and control functions. Using T-SQL, we can write our own procedures and functions with local variables. tr> 3 Proprietary SQL is open for use and is common in RDBMS software. T-SQL is specific to SQL Server and proprietary. 4 Query sequence Submit multiple queries Using T-SQL, multiple queries can be submitted in batches. 5 Function 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!