What is the difference between SQL and T-SQL (Sybase) ? It
could be a too masic question. But i have recently readed
the below blog and saw T-SQL(Microsoft). Thats why is there
any difference between T-SQL(Microsoft) vs T-SQL(Sybase).
Obviously..But i don't want to go into that now.
my question is,
Difference between SQL vs T-SQL(Sybase)
Subject: SQL vs T-SQL(Sybase)
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 29 Nov 2012 01:45:39 -0800
X-Trace: forums-1-dub 1354182339 172.20.134.41 (29 Nov 2012 01:45:39 -0800)
X-Original-Trace: 29 Nov 2012 01:45:39 -0800, 172.20.134.41
Xref: forums-1-dub sybase.public.ase.general:31554
Article PK: 74443
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
Subject: Re: SQL vs T-SQL(Sybase)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Date: 29 Nov 2012 08:00:24 -0800
X-Trace: forums-1-dub 1354204824 172.20.134.152 (29 Nov 2012 08:00:24 -0800)
X-Original-Trace: 29 Nov 2012 08:00:24 -0800, vip152.sybase.com
Xref: forums-1-dub sybase.public.ase.general:31557
Article PK: 74444
The answer is essentially the same as from that link
SQL is an abstract concept, an abstract query langauge.
T-SQL is Sybase's implementation of SQL, much as PL/SQL is
Oracle's implementation of SQL and "Informix SQL" was Informix's
(there is also a somewhat different T-SQL from Microsoft; it
has the same roots - some 20 years ago it was the same thing,
but Sybase and Microsoft then parted ways)
Both SQL and T-SQL have changed over time and continue to evolve.
Some new features are first thought up and implemented
by vendors before a standard syntax is determined by ANSI
(the vendors certainly don't want to wait if customers are demanding
functionality not covered by the existing standard).
Some vendor-implemented features ANSI never will incorporate.
Some features thought up by other parties, perhaps being standardized
by ANSI, will be implemented by vendors before the standard
is finalized and so the syntax may or may not match the final
standard. In other cases, some ANSI features won't be implemented
until after they are standardized, and some ANSI features never
will be implemented if the vendors don't see any commercial
demand for the feature.
To support their customers, vendors generally won't stop supporting
the syntax they originally implemented even if the ANSI standard
settles on something somewhat differently, though additional support
may be added to also support the new ANSI definition.
(TSQL, for instance, supports both the older *= outer join syntax
and the newer LEFT OUTER JOIN syntax - we didn't make customers
rewrite all their application code when we started supporting
the new ANSI syntax).