Difference in SQL

Question

Difference in SQL

todd.ayers

SSCommitted

Points: 1837
More actions
May 13, 2013 at 12:40 pm

#273857

What is the difference between just SQL and T-SQL?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

Both Have SQL = "Structured Query Language" in their names;

As Far as I know, T-SQL (Transact SQL) is the nickname for Microsoft's version of SQL, as opposed to PL SQL(Oracle's Procedural Language/Structured Query Language) for example.

bot have different adherences to the ANSI standards for SQL, and both have numerous proprietary extensions to the language as well

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jack Vamvas SSChasing Mays Points: 651 More actions · Answer 2

SQL is the the programming language used to manage relational database systems. Regardless of the datbase server system - there is normally a DML and DDL aspects to the language

Jack Vamvas
sqlserver-dba.com

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

SQL is the original defined language and is maintained by ISO. Transact-SQL (T-SQL) is the name that Sybase gave to their version of the language and since SQL Server is based off Sybase's old product it has the same name.

That's the precise definition. But, unless you're writing a book or something, it's pretty safe to refer to SQL or T-SQL interchangeably. I'd get more picky about it if you were comparing Oracle to SQL Server or DB2 or MySQL or some other SQL-based data management system.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

subhajeetsur SSC-Addicted Points: 453 More actions · Answer 4

SQL: a language for talking to the database. It lets you select data, mutable and create database objects (like tables, views, etc.), change database settings.

T-SQL: (procedural) extensions for SQL used by SQL Server

OTF SSCertifiable Points: 6104 More actions · Answer 5

subhajeetsur (5/16/2013)
SQL: a language for talking to the database. It lets you select data, mutable and create database objects (like tables, views, etc.), change database settings.
T-SQL: (procedural) extensions for SQL used by SQL Server

What makes Microsoft's SQL Extensions (TSQL) Procedural, if I might ask?

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 6

subhajeetsur (5/16/2013)
SQL: a language for talking to the database. It lets you select data, mutable and create database objects (like tables, views, etc.), change database settings.
T-SQL: (procedural) extensions for SQL used by SQL Server

The extensions to TSQL are not necessarily procedural. For example, the CONVERT function isn't procedural. And, for sure, TSQL isn't procedural by nature. Yes, things like While loops are procedural but just because you're using TSQL doesn't mean that you're writing procedural code.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)