Difference Between SQL and T-SQL

In this article, we will understand the difference between SQL and T-SQL.

SQL

• #It is a non-procedural language.

• Relational databases use SQL.

• It stands for Structured Query Language.

• It uses queries to view and manipulate data.

• Use DML and DDL operations - data manipulation language and data definition language.

• It is considered an open source language.

• It helps in data manipulation and data control.

• When using SQL, data will be transferred one by one.

T-SQL

• It is a Microsoft product.

• It is called Transact Structured Query Language.

• It provides a high degree of control to the developer/programmer.

• It works best and provides good performance through Microsoft SQL Server.

It’s simple.

• It’s easy to understand.

• It allows inserting multiple rows into the table.

• This is done with the help of "BULK INSERT" statement.

• "SELECT INTO" ' statement is used in T-SQL.

• Among them, the 'NOT EXISTS' clause can be used with the 'SELECT' statement.

• It is a procedural language.

• It is considered proprietary.

• It contains functions and local variables.

• Transfer data in batches.

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