Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between SQL and T-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.
1K+ Views
