ajitnayak

 Profile Answers by ajitnayak 

• Feb 28th, 2009

 

As the name indicates that T-SQL means transact SQL queries developed by Microsoft. It is a programming language and the difference between SQL and T-SQL is SQL is the base class for T-SQL and T-SQL is inherited from SQL having some extra features as compared to SQL.

psingla

 Profile Answers by psingla Questions by psingla

• Mar 3rd, 2010

 

SQL/PL-SQL/T-SQL

SQL(Structured Query Language): is a ANSI complinent languge to operate a database.
It includes DDL(Create,alter,drop,truncate),DML(select,insert,delete,update) and  DCL(Grant,revoke,commit,rollback) queries.
All these elementary queries.

PL-SQL(Programing Language SQL):

• It is built upon SQL.
• N number of sql queries can be combined to make a single Action.
• Used by Oracle
• Used into transactions
• Example procedure,packages,triggers are the part of Pl-sql

T-SQL(Transaction SQL):

• It is too built upon SQL.
• N number of sql queries can be combined to make a single Action.
• Used by Microsoft
• Used into transactions
• Example procedure,triggers are the part of PL-SQL