Difference Between SQL and T-SQL

MySQLDatabaseT-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.

raja
Published on 25-Mar-2021 05:40:12
Advertisements