Register now or log in to join your professional community.
T-SQL, also known as Transact SQL is a set of programming extensions from Sybase and Microsoft that add several features to the SQL, whereas PL SQL is a procedural language to create SQL
T SQL is term from Microsoft for Programming SQL Language, PL SQL is term from Oracle for Programming Language.
t-sql is a part of microsoft where as pl/sql is of oracle
T-SQL (tha stands for Transact SQL) is the SQL language used for Microsoft SQL Server, while PL-SQL is the Oracle version of the SQL Language.
PL-sql is a procedural language used by oracle and T-sql is a proprietary language used by microsoft in sql server.
Both of them are for relational database the only difference between PL/SQL and T-SQL is that PL/SQL is product of ORACLE where as T-SQL is of Microsoft product
Although both systems use a version of Structured Query Language, or SQL, MS SQL Server uses Transact SQL, or T-SQL, which is an extension of SQL originally developed by Sybase and used by Microsoft. ... PL/SQL in Oracle can also group procedures together into packages, which can't be done in MS SQL Server.
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables.
1) t-sql is a proprietary procedural language used by Microsoft in SQL Server.
2)PL/SQL is a proprietary procedural language used by Oracle .
1. SQL or Structured Query Language was developed by IBM for their product "System R".
Later ANSI made it as a Standard on which all Query Languages are based upon and have extended this to create their own DataBase Query Language suits. The first standard was SQL-86and latest being SQL:2011
2. T-SQL or Transact-SQL was developed by Sybase and later co-owned by Microsoft SQL Server.
3. PL/SQL or Procedural Language/SQL was Oracle Database, known as "Relation Software" that time.
TSQL is a set of procedural extensions for SQL used my MS SQL Server where as PL/SQL is procedural programming language with embedded SQL used by all relational databases like Oracle.
TSQL is an ANSI standard structured query lnguage developed by Sybase and used by Microsoft. PL/SQL is a structed query language with programming abilities such as control structures and cursors.
