Structured Query Language (SQL):
Structured Query Language (SQL) has a specific design motive for defining, accessing and changement of data. It is considered as non-procedural, In that case the important elements and its results are first specified without taking care of the how they are computed. It is implemented over the database which is driven by a database engine. The primary work of the database engine is to interpret SQL queries and find the accessing technique for getting different data structures in the database. This is also an important feature of the data engine so used to evaluate the accuracy and efficiency of the outcomes.
Here are few groups of commands included in the SQL – DDL (Data Definition Language) and DML (Data Manipulation Language). DDL is used for describing and modification of several data structures. While DML is intended to access and change of the data save within the data structures defined by DDL.
Transact-SQL (T-SQL) is an extension of SQL. It is considered as procedural language, unlike SQL that is used by SQL server. It is helpful in doing operations like getting the data from a single row, addition of new rows, getting multiple rows. The syntax is different from others like PL-SQL. However, it has the same functionality and generates similar results as other languages. This is the Microsoft implementation of the structured query language for SQL server.
Difference Between Structured Query Language (SQL) and Transact-SQL (T-SQL):
|1.||Basic||It is a Non-procedural.||It is a Procedural.|
|2.||Functions provided||Data manipulation and controlling functions are provided||Procedural programming functions and local variable are provided|
|3.||Feature||It is an Open language||It is a Proprietary|
|4.||Submission of Query||One after another||Bulk submission.|
|5.||Special Features||Several DDL, DML and other operation are provided||All the features of SQL along with transaction control, error and exception handling.|
|6.||Derived||It is a base programming language.||It is derived from SQL and enhanced form of SQL.|
- Difference between Structured, Semi-structured and Unstructured data
- Features of Structured Query Language (SQL)
- Difference between Structured and Object-Oriented Analysis
- Difference Between Machine Language and Assembly Language
- Difference Between Assembly Language And Machine Language
- Difference Between C Language and LISP Language
- Difference between Hardware Description Language and Software Language
- SQL | Difference between functions and stored procedures in PL/SQL
- Difference between T-SQL and PL-SQL
- Difference between SQL and T-SQL
- SQL query using COUNT and HAVING clause
- SQL Query to find the Nth Largest Value in a Column using Limit and Offset
- SQL | SELECT Query
- SQL | Query Processing
- What are the Best Ways to Write a SQL Query?
- SQL Query Complexity
- SQL query to find unique column values from table
- SQL | Query to select NAME from table using different options
- Difference between %d and %i format specifier in C language
- What is the difference between a language construct and a “built-in” function in PHP ?
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.