SYBASE Vs. SQL
Anjal Amin
I was just wondering what the differences were between SyBase and SQL.
From what I understand, they are the similar except syntactically (?).
Thanks,
Anjal Amin--
()=========================()
// ____/__ __/ ____/ //\\
// / / / _/ // ()
// __/ / ____/ // //
// / / / // //
// _/ _/ _/ // //
()=========================() //
\\ am...@midget.towson.edu \\//
()=========================()
Anjal Amin
I was just wondering, what are the similarities and/or differneces
between SyBase and SQL? From what I understand, they're basically the
same except syntactically.
Thanks!
Anjal Amin
Teresa A Larson
|>
|> I was just wondering what the differences were between SyBase and SQL.
|> From what I understand, they are the similar except syntactically (?).
Sybase is a company whose main product is the Sybase SQL-Server which is
a relational database management system (RDBMS). SQL is structured
query language which is the standard language for RDBMS'.
The major RDBMS vendors all support SQL (with varying levels of
compliance to the ANSI standard). They also provide extensions to SQL
to enhance their particular product. In Sybase's case, they call their
implementation of SQL "Transact SQL". Transact SQL includes control flow
statements (looping statements, IF statement, to mention a couple).
Hope this helps.
Teresa Larson
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
| Teresa A. Larson - Hughes STX Corporation |
| NASA/GSFC Code 933.0 voice: (301) 286-7867 |
| Greenbelt, Maryland 20771 fax: (301) 286-1777 |
| Teresa...@gsfc.nasa.gov |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
Standard disclaimer ...
Steve Wright
Terry Miesse
|> In article <3ag59a$8...@news.umbc.edu>, am...@midget.towson.edu (Anjal Amin) says:
|>
|> >I was just wondering what the differences were between SyBase and SQL.
|> >From what I understand, they are the similar except syntactically (?).
|>
I'm going to misinterpret your question a little bit... I think this may
have been covered in a previous post (Theresa Larson), but I'm not sure.
Sybase has a "dialect" of SQL called Transact-SQL. This contains Sybase
extensions to SQL-- basically, some Sybase-specific ways of doing things.
With Sybase 10, Transact-SQL is ANSI compliant (although for some functions,
the ANSI way isn't the default), with Sybase extensions. Pre-System 10,
T-SQL was _NOT_ fully ANSI compliant.
Sybase, of course, feels that their way of doing things is better than the
ANSI way, so they give you the ability to do both in System 10.
|> They are the same except that they are completely different :)
|>
|> - SYBASE is a Database Management System (DBMS) which manages the storage of
|> and access to a set of data.
|>
|> - SQL is the Structured Query Language used to formulate queries of this data.
|> SQL exists totally separate from SYBASE. Many DBMS systems use one form of
|> SQL or another to access DB data. There are various standards/dialects of
|> SQL just like C or Pascal.
|>
|> Bottom line, SQL is a language. SYBASE is one example of a system on
|> which SQL can be executed.
|>
|> Steve Wright
|> wri...@waterw.com
|>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Terry Miesse | All opinions are my own.
Mead Data Central | All quotes are shamelessly stolen.
(LEXIS/NEXIS) |
I/S Shared Services | "Shoot first, and call whatever you
(513) 865-6800 x6711 | hit the target."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~