- Trending Categories
- Data Structure
- Operating System
- C Programming
- 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).
152 Lectures 16 hours
87 Lectures 5.5 hours
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, 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.
|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.|
- Structured Query Language (SQL)
- Difference Between SQL and T-SQL
- Difference Between T-SQL and PL-SQL
- Difference between SQL and PL/SQL
- Difference between Static SQL and Dynamic SQL
- Difference between SQL and NoSQL
- Difference between Delete and truncate in sql query
- Difference between Open SQL, Native SQL in SAP HANA
- Difference between MySQL and SQL Server
- Difference between Oracle and SQL Server
- Difference between DELETE and DROP SQL
- Difference between Join and union in SQL
- Difference Between COMMIT and ROLLBACK in SQL
- Difference Between DELETE and DROP in SQL
- What is the difference between SQL and MySQL?