8.24.2012

Difference between SQL and T-SQL in SQL Server

Difference between SQL and T-SQL in SQL Server
S.No SQL T-SQL
1
SQL stands for Structured Query Language
T-SQL stands for Transact SQL
2
ANSI/ISO(American National Standards Institute) standard database query language
This is implementing in SQL SERVER. T-SQL can have one or more queries.
3 Set of queries submitted individually to the server. It is a batch program, and submit to the server in a single shot. We can run all the programs at any time.
4 It is developed by IBM. T-Sql is implemetation of SQL in Microsoft SQL Server.

No comments:

Post a Comment