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(Structured Query Language) and T-SQL(Transact-SQL).
SQL
SQL, Structured Query Language is a non-procedural language and is used by database engines to interpret SQL queries to create/modify/access the database elements.
T-SQL
T-SQL, Transact-SQL, is a procedural extension to SQL, used by SQL Server. It is similar to PL/SQL of Oracle.
Following are the important difference between SQL and T-SQL.
| Sr. No. | Key | SQL | T-SQL |
|---|---|---|---|
| 1 | Type | SQL is non-procedural by nature. | T-SQL is procedural by natue. |
| 2 | Methods | SQL provides data manipulation and controlling functions. | With T-SQL, we can write own procedures, functions with local variables. |
| 3 | Proprietary | SQL is open to use and is common across RDBMS softwares. | T-SQL is specific to SQL Server and is proprietary. |
| 4 | Query order | Multiple querires are submitted one by one. | Using T-SQL, multiple queries can be submitted in batches. |
| 5 | Features | DDL, DML, DQL operations are provided. | Apart from SQL features, transaction controls, exception handlings etc. are provided. |
Updated on: 27-Nov-2019
492 Views
Advertisements