Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Difference in SQL Expand / Collapse
Author
Message
Posted Monday, May 13, 2013 12:40 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 1:56 PM
Points: 59, Visits: 120
What is the difference between just SQL and T-SQL?
Post #1452271
Posted Monday, May 13, 2013 12:56 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 12,744, Visits: 31,078
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1452277
Posted Monday, May 13, 2013 3:18 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:28 AM
Points: 31, Visits: 307
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
Post #1452335
Posted Tuesday, May 14, 2013 4:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 14,802, Visits: 27,278
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1452487
Posted Thursday, May 16, 2013 1:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 8:55 AM
Points: 51, Visits: 27
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

Post #1453353
Posted Thursday, May 16, 2013 9:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
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?
Post #1453631
Posted Thursday, May 16, 2013 12:36 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:00 PM
Points: 35,967, Visits: 30,258
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." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1453733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse