- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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. |
- Related Articles
- 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 Delete and truncate in sql query
- Difference between SQL and NoSQL
- 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
- SQL Query to Convert Rows to Columns in SQL Server
Advertisements