Shulou(Shulou.com)06/02 Report--

This article mainly introduces what are the differences between T-SQL and SQL, the article is very detailed, has a certain reference value, interested friends must read it!

Difference: structured query language SQL is the standard language of relational database, which has been adopted by many commercial DBMS products, making it a mainstream language in the field of relational database. T-SQL is a version of SQL and can only be used on SQL SERVER, and provides basic functions such as database scripting language, such as C #.

The difference between SQL and T-SQL

SQL is the abbreviation of Structrued 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 database, it has been adopted by many commercial DBMS products, making it a mainstream language in the field of relational database. It includes not only data query functions, but also insert, delete, update and data definition functions.

T-SQL is a version of the SQL language and can only be used on SQL SERVER. It is the enhanced language of ANSI SQL and provides standard SQL commands. In addition, T-SQL has also done a lot of supplements to SQL, providing database scripting languages, that is, basic functions similar to C, Basic and Pascal, such as variable description, flow control language, function functions and so on.

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

Here's an explanation of what "T-SQL provides the DDL and DML capabilities of standard SQL".

The languages of relational databases are divided into three categories: data definition language, namely 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 SQL database; DML data manipulation language, SQL data processing and other operations are collectively referred to as data manipulation language.

Extended material: the origin of T-SQL.

The American National Bureau of Standards (ANSI) and the International Organization for Standardization have formulated the SQL standard. The American National Bureau of Standards has issued the corresponding American standard with the International Organization for Standardization (which can be understood as convenient for domestic use). In 1992, the International Organization for Standardization and International Electrotechnical Commission (IEC) issued the SQL international standard, called SQL-92. The corresponding standard issued by the National Bureau of Standards of the United States is ANSI SQL-92. Although there are some differences in the version of SQL used by different databases, most follow the ANSI SQL standard. SQL Server uses an extended set of ANSI SQL-92, called T-SQL.

These are all the contents of this article entitled "what are the differences between T-SQL and SQL". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.