What is the difference between T-SQL and SQL?

Difference: Structured query language SQL is the standard language of relational databases and has been adopted by many commercial DBMS products, making it a mainstream language in the field of relational databases. T-SQL is a version of SQL and can only be used on SQL SERVER; it also provides a database scripting language, which is a basic function similar to C.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

The difference between SQL and T-SQL

SQL is the abbreviation of Structured Query Language, that is, structured query language. It is the standard responsible for interacting with databases maintained by ANSI (American National Standards Institute). As the standard language of relational databases, it has been adopted by many commercial DBMS products, making it a mainstream language in the field of relational databases. It not only includes data query functions, but also includes insertion, deletion, update and data definition functions.

T-SQL is a version of the SQL language and can only be used on SQL SERVER. It is an enhanced version of ANSI SQL language and provides standard SQL commands. In addition, T-SQL also makes many additions to SQL and provides a database scripting language, that is, basic functions similar to C, Basic and Pascal, such as variable description, flow control language, functional functions, etc.

T-SQL provides the DDL and DML functions of standard SQL, plus extended functions, system stored procedures, and programming structures (such as IF and WHILE) to make program design more flexible.

Here to explain what "T-SQL provides the DDL and DML functions of standard SQL" means.

The languages ​​of relational databases are divided into three categories. They are data definition language, which is DDL (Data Defining Language); data manipulation language DML (Data Manufacturing Language) and data control language DCL.

SQL is a standard relational database language that integrates DDL, DML, and DCL. Among them, DDL data definition language is used to define and manage all objects in the SQL database; DML data manipulation language, data processing and other operations in SQL are collectively called data manipulation languages.

Extended information: The origin of T-SQL.

The American National Standards Institute (ANSI) and the International Organization for Standardization have developed SQL standards. The American National Bureau of Standards has issued American standards corresponding to the International Organization for Standardization (which can be understood as convenient for use in this country). In 1992, the International Organization for Standardization and the International Electrotechnical Commission (IEC) released an international standard for SQL, called SQL-92. The corresponding standard subsequently released by the American National Standards Institute is ANSI SQL-92. Although there are some differences in the SQL versions used by different databases, most follow the ANSI SQL standard. SQL Server uses an extension set of ANSI SQL-92, called T-SQL.

For more knowledge about computer programming, please visit: Programming Video! !

The above is the detailed content of What is the difference between T-SQL and SQL?. For more information, please follow other related articles on the PHP Chinese website!