Difference Between SQL and T-SQL

In this post, 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 query to view and manipulate data.

• DML and DDL operations are used- Data manipulation language, and data definition language.

• It is considered as an open-source language.

• It helps in the manipulation of data and data controlling.

• Transfer of data happens one by one when SQL is used.

T-SQL

• It is a Microsoft product.

• It is known as Transact Structure Query language.

• It gives a high degree of control to the developers/programmers.

• It works its best, and provides good performance with Microsoft SQL server.

• It is easy.

• It is simple to understand.

• It allows the insertion of multiple rows into a table.

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

• The ‘SELECT INTO’ statement is used in T-SQL.

• In this, the ‘NOT EXISTS’ clause can be used with the ‘SELECT’ statements.

• It is a procedural language.

• It is considered proprietary.

• It contains functions and local variables.

• It transfers data in bulk.