The difference between SQL and T

For SQL, in my previous blog, what is SQL Server database? What's the difference from an Access database? It has been highlighted in SQL as the standard computer language for accessing and processing databases, so there is no undue emphasis here. Now let's talk about T-SQL.

T-SQL, as an extended language for SQL, is an enhanced version of the SQL programming language, which is the primary language used to communicate the application to SQL Server. T-SQL provides the DDL and DML capabilities of standard SQL, plus extended functions, system stored procedures, and program design structures such as if and while to make the Cheng design more resilient. Here's what you mean by "T-SQL provides the DDL and DML capabilities of standard SQL." The language of a relational database is divided into three categories: The data definition language, which is the DDL (data defining Language), the Information manipulation language DML (manufacturing Language), and the Data Control Language DCL. SQL is a standard relational database language which integrates DDL, DML and DCL. Where the DDL data definition language is used to define and manage the language of all objects in the SQL database, the DML data manipulation language, and the operation of data in SQL are collectively referred to as data manipulation languages.

Finally, the origin of T-SQL. The United States National Standards Office (ANSI) and the International Organization for Standardization have developed a SQL standard, the United States National Standards Bureau issued with the International Organization for Standardization of the United States standards (can be understood to facilitate domestic use), 1992 International Organization and International Electrotechnical Commission (IEC) publishes the International Standard for SQL, called SQL-92. The corresponding standard issued by the U.S. National Standards Bureau 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.

In a nutshell, SQL, as a structured query language, is the standard language for standard relational databases, and T-SQL is the language used in SQL Server Extensions on a SQL basis.

Thanks for the original, transfer from http://blog.csdn.net/gaoying_blogs/article/details/7844886

The difference between SQL and T