In this blog, we discuss the difference between SQL and T-SQL
Structured Query language (SQL):
A structured Query language is a computer language for a relational database system. Relational database system like MySQL oracle Sybase Informix uses SQL as the standard database language for storing retrieving manipulating data and storing it in a relational database.
Here are some SQL commands that are used for communication with databases like storing retrieving manipulating data.
Data definition language used for creating, dropping, altering, truncate in database.
Data manipulation language is used to insert, update, delete data in the database.
Data control language used for Revoke and grant data.
Transaction control language used for commit, rollback data.
Data Query language used for select data.
Transact structured Query language (T-SQL):
TSQL stands for Transact structured Query language which is a Microsoft tool and extension of SQL language. TSQL is mainly used for writing an entire program of block function procedure that defines how things need to be complete and creating an application in which each application sends transact query over SQL server and there is no interaction with the database. It executes as a whole block with the extension of SQL language.
There different types of T-SQL function is used in T-SQL :
Scalar function
Ranking function
Aggregate function
Reset function
Difference between SQL and T-SQL:
SQL
Structured Query language (SQL)
It stands for Structured Query language and it is developed by IDM.
The structured Query language is used to look over data using queries.
In Structured Query language, the age we insert SQL into T-SQL.
RGB is used for managing data.
In Structured Query language, we perform DML and Doperationsion.
It executes es single statement.
In SQL, there is an interaction wiDatabasease server.
It is mainly used for manipulating data
T-SQL
Transact Structured Query language (T-SQL)
It stands for Transact Structured Query language and it is developed by Microsoft.
Transact Structured Query language used for creating applications and adding business logic.
In Transact Structured Query we do not insert T-SQL into SQL.
In which we can see an extension of the server used by MS SServerver.
In Transact Structured Query, there are blood od codes that are used to write function and procedure.
It executes as a whole block.
In TSQL, there is no interaction with the database server.
It is mainly used for the creation ng applications.