What is the difference between SQL & T-SQL?

Editorial / Best Answer

Answered by: NITIN TOMER

  • Sep 6th, 2011


sql is a structured query language........and t-sql is implementing on sql server........and t-sql having some more queries than sql .

Showing Answers 1 - 2 of 2 Answers

Prashant Kumar

  • Jan 24th, 2007
 

SQL is the Structured Query Language, the ANSI/ISO Standard database language. SQL Server's implementation of the language is called Transact-SQL (T-SQL).

  Was this answer useful?  Yes

prashant10153

  • Jan 24th, 2007
 

SQL is the Structured Query Language, the ANSI/ISO Standard database language. SQL Server's implementation of the language is called Transact-SQL (T-SQL).

  Was this answer useful?  Yes

Seshi

  • Feb 27th, 2007
 

SQL- set of sqls  are submitted individually to the database server.

T-SQL-  the batch program is written where in all commands are submitted to the server in a single go. usually batches are run overnight and and all inserts and updates happen and these batches are scheduled. where as  sqls' are to run separately.....

all sqls' are put in a file and schedule them called --t-sql .. besides , it offers some other commands too.

Seshi reddy

  Was this answer useful?  Yes

Prasad

  • Apr 10th, 2007
 

T-SQL is used as programming language for Sybase/Sqlserver similar to PL/SQL for Oracle.  this block of code (T-SQL or PL/SQL ) can contains SQL statements.

  Was this answer useful?  Yes

chada

  • May 30th, 2007
 

As c is a programming language, T-Sql is also the same to SQL
in other words T-Sql is implemetation of SQL in Microsoft SQL Server

  Was this answer useful?  Yes

NITIN TOMER

  • Sep 6th, 2011
 

sql is a structured query language........and t-sql is implementing on sql server........and t-sql having some more queries than sql .

  Was this answer useful?  Yes

Abdul Khadir

  • Jan 3rd, 2012
 

SQL is the Structured Query Language. it is developed by IBM.
TSQL is the Transact SQL. it is implementation of the SQL server. it is developed by Microsoft.
TSQL is used in writing the procedure and some advanced concepts are written by this.

  Was this answer useful?  Yes

Syed Umar Abbas

  • Mar 28th, 2012
 

Microsoft SQL Server have some more additions to Database Standard Query Language (SQL) is called T-SQL

  Was this answer useful?  Yes

kandriga murali

  • Dec 8th, 2013
 

1) .SQL is non-procedural language since it deals with what data to be extracted.Whereas T-SQL is procedure language since it deals with what data to be executed and how it should be displayed.
2) . SQL can executed only single command whereas T-SQL can executed multiple statement at time.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions