Difference between SQL and T-SQL

Difference between SQL and T-SQL
Written by Sagar RabidasNovember 20, 2021
4 min read
T-SQL
3 VIEWS 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 3 VIEWS SHARE
Sagar Rabidas

Software Developer

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.

blogpost

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

blogpost

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.

SQL
TSQL
SQL vs TSQL
3 VIEWS 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 3 VIEWS SHARE
Was this blog helpful?
You must be Logged in to comment
Code Block
Techiio

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

facebooklinkdeintwitter

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Copyright techiio.com @2020 Kolkata, India
made with by Abhishek & Priyanka Jalan
Copyright techiio.com @2020
made with by Abhishek & Priyanka Jalan