In this post, we will understand the difference between SQL and T-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.
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.