Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

?What is the difference between t-sql and pl/sql

user-image
Question ajoutée par Tarek ABBOUD , معاون رئيس شعبة البرمجيات و ادارة النظم المعلوماتية , الشركة السورية للغاز
Date de publication: 2017/08/14

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

Amit Tiwari
par Amit Tiwari , Technical Solution Consultant , Statefarm Insurance

T SQL is term from Microsoft for Programming SQL Language, PL SQL is term from Oracle for Programming Language.

Ashfaque Choudhary
par Ashfaque Choudhary , Programmer Analyst , Almarai

t-sql is a part of microsoft where as pl/sql is of oracle 

Virgílio Fernandes Jr
par Virgílio Fernandes Jr , Data Warehouse Analyst , Dafiti Group

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.

Mohamed Taimour Ahmed
par Mohamed Taimour Ahmed , Production Analyst , IQVIA

PL-sql is a procedural language used by oracle and T-sql is a proprietary language used by microsoft in sql server.

Mohsin Alvi
par Mohsin Alvi , OSS Support And Delievery Engineer Engineer , Aircom International

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

Nitin Shinde
par Nitin Shinde , Junior Analyst , Amazon

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.

bhupesh bhadekar
par bhupesh bhadekar , Sr. Software Developer , Finesse Technology LLC

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.

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?