Difference between SQL and T-SQL(Microsoft SQL Server 2000)

pts.
Tags:
Database Management Systems
DataCenter
MySQL
SQL Server
What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

Answer Wiki

Thanks. We'll let you know when a new response is added.

From TechTarget.com:

What is the difference between SQL and T-SQL? Why would a company use one over the other?
This question posed on 14 February 2002

ANSI SQL is the standard Structured Query Language. Most database vendors support SQL. T-SQL is Microsoft’s “flavor” of SQL; it is ANSI SQL with Microsoft’s extensions. A company could choose to use T-SQL over SQL if they have a database application that communicates with a MS SQL Server database only. Therefore a developer could use the “extras” for improved performance, ease of SQL coding, etc. A company could chose SQL because a front-end may have to communicate with several relational database management systems (RDBMs) therefore a programmer could rely on the fact that most database understand ANSI SQL.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BenjiT
    I am assuming you mean ANSI SQL regarding the differences. Most database engines today support some level of ANSI compliance. The problem is (as always) the standards groups lag behind the technalogical needs. SQL 2k is ANSI compliant for different ANSI Specifications. Obviously this question is based on your philosophy of software development. Ask these questions first: Does your application require operations against more than one database engine? If so, are you willing to give up performance to go with the lowest common denominator? If the answer is yes to both the above questions then the question is how to I utilize SQL 2K in an ANSI Compliant fashion. Yes it can be used with ANSI only query methods.
    0 pointsBadges:
    report
  • Dmarkcox
    SQL is the structured query language. T-Sql is a development environment for creating stored procedures. Every environment needs a way to create batches of SQL statements. Microsoft provides it in the form of T-Sql. Note some commands in T-Sql such as Begin, End, Looping constructs, and others.
    0 pointsBadges:
    report
  • BenjiT
    TSQL can be used for much more than just creating stored procedures. TSQL is Microsofts implementation of the SQL language. It has Data Definition Language, looping and decision constructs, etc. all of which are ANSI specified. In addition it supports ANSI specifications for features such as schema exposure separating the user from the base table storage so that schema queries will work in both SQL Server and other ANSI compliant databases. You will see this capability demonstrated in the INFORMATION_SCHEMA views. So what is not ANSI compliant or transportable. Perhaps items such as User Defined Functions or Table Variables. If you don't use these kinds of features in your TSQL code it will be transporable and thus ANSI compliant. TSQL and PL/SQL are supersets of the ANSI standards. To what version fo teh ANSI Standard they comply depends on teh version of the product. This is true of almost any database engine including others such as Sybase, Sybase SQL Anywhere (which us old timers remember as Watcom), MySQL, Posgres SQL, RBASE, Informix.......
    0 pointsBadges:
    report
  • Kpatel
    Thank you all for your responses. It was really helpful.
    0 pointsBadges:
    report
  • Kpatel
    [...] SQL: What is the difference between normal SQL and T-SQL? Posted on March 31, 2011 by mytechconnect http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-se... [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following