Difference between SQL and T-SQL

Difference between SQL and T-SQL
Techiio-author
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
Techiio-author
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?
techiio-price-plantechiio-price-plantechiio-price-plantechiio-price-plantechiio-price-plan
You must be Logged in to comment
Code Block
Techiio-author
Sagar Rabidas
Software Developer
Techiio-followerTechiio-followerTechiio-followerTechiio-followerTechiio-follower
+8 more
300 Blog Posts
14 Discussion Threads
Trending Technologies
15
Software40
DevOps47
Frontend Development24
Backend Development20
Server Administration17
Linux Administration26
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Recommended Blogs
1
Techiio-logo

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:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance