SQL vs. PL/SQL vs. T-SQL
SQL is a standard query language of the database.
Where the PL/ SQL stands for "Procedural Language extensions SQL." It is used in the Oracle database and the extension of Structured Query Language (SQL). Whereas, T-SQL stands for "Transact-SQL.," which is the extension of Structured Query Language (SQL) used in Microsoft.
Difference between SQL and T-SQL
Difference between SQL and PL/SQL
Difference between T-SQL and PL-SQL
Difference between SQL and T-SQL in points
SQL and T-SQL are the two sides of one coin which name is Microsoft SQL Server.
1. SQL and TSQL as a database language:
SQL stands for Structured Query language, which is used to execute a single query at a time with the insert/update/delete and select statement. Users cannot be able to perform many statements at the same time.
T-SQL is used to work with different transactional activities into SQL database. The user uses many programming techniques when utilizing the T-SQL.
The SQL statements are used to create web pages, analytical reports, and screens. The SQL statements are used for generating and connecting the database in the applications. If the user wants to update the application, then sql statement generates the support team.
T-SQL is a transactional sql which is used to perform the back-end transactions of the application to use techniques of programming language. T-SQL is used to add the business logic in the application and used to build the application logic.
3. Standards of SQL and T-SQL:
SQL is ANSI/ISO Standard database. The Server implementation of SQL Server is the language called Transact-SQL.
4. Development companies:
IBM has developed SQL. TSQL is the implementation of the SQL server. Microsoft has developed it.
5. SQL and T-SQL as Data or Program Oriented:
SQL is a Data-Oriented Language used to analyze the data for simple queries. It uses insert, update, and delete command.
T-SQL is a transactional language that is used to create applications like; we add business logic in the request.
6. SQL and T-SQL Objects:
SQL is used to write the DDL (Data Definition Language) statements as the DML (Data Manipulation Language) statements.
T-SQL is mainly used to write views, procedures, triggers, and functions. And it is called T-SQL objects.
7. Instructions of databases:
The sql statement executes only one statement at a time, but the T-SQL statements have a set of SQL statements and it executes one by one.
8. Embedding both the SQL and T-SQL
We can integrate the SQL into the T-SQL but we cannot insert the T-SQL code in the SQL.