Discussion:
what are main differences between Sybase sql programming and MS SQL progamming?
(too old to reply)
Britney
2005-01-24 17:46:57 UTC
Permalink
Hi guys,
I know most of syntaxes should be be the same, such as select
statement, create table, drop table statement.
but I believe there should be some differences between them in programming,
I think sybase is more strict than MS SQL right?
Thanks
Brit
Wayne Snyder
2005-01-24 18:46:46 UTC
Permalink
This link points to a file which tells how to convert Sybase to SQL code. It
should include most of what you need..

http://www.microsoft.com/downloads/details.aspx?FamilyID=e7541305-891f-494a-b58b-2eed819c4411&DisplayLang=en
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
Post by Britney
Hi guys,
I know most of syntaxes should be be the same, such as select
statement, create table, drop table statement.
but I believe there should be some differences between them in
programming,
Post by Britney
I think sybase is more strict than MS SQL right?
Thanks
Brit
Mike Epprecht (SQL MVP)
2005-01-24 20:35:55 UTC
Permalink
Hi

I work with the 2 all day long.
Sybase is far behind on ANSI standards (like the terrible =* join syntax).
You will not get one code base to work well against both. Once Sybase 15
gets released, writing ANSI code is easier.
Sybase is stricter because it has lagged behind.

The link below is great.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: ***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/
Post by Wayne Snyder
This link points to a file which tells how to convert Sybase to SQL code. It
should include most of what you need..
http://www.microsoft.com/downloads/details.aspx?FamilyID=e7541305-891f-494a-b58b-2eed819c4411&DisplayLang=en
Post by Wayne Snyder
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
Post by Britney
Hi guys,
I know most of syntaxes should be be the same, such as select
statement, create table, drop table statement.
but I believe there should be some differences between them in
programming,
Post by Britney
I think sybase is more strict than MS SQL right?
Thanks
Brit
Scott Morris
2005-01-25 17:41:29 UTC
Permalink
ASE v12 supports ANSI join syntax. SQL Anywhere (current version per online
doc) does as well. In addition, both support ANSI SQL-92 entry level.
Sybase also has a MS-to-ASE migration guide available on its website.
Post by Mike Epprecht (SQL MVP)
Hi
I work with the 2 all day long.
Sybase is far behind on ANSI standards (like the terrible =* join syntax).
You will not get one code base to work well against both. Once Sybase 15
gets released, writing ANSI code is easier.
Sybase is stricter because it has lagged behind.
The link below is great.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
Post by Wayne Snyder
This link points to a file which tells how to convert Sybase to SQL
code.
Post by Mike Epprecht (SQL MVP)
It
Post by Wayne Snyder
should include most of what you need..
http://www.microsoft.com/downloads/details.aspx?FamilyID=e7541305-891f-494a-b58b-2eed819c4411&DisplayLang=en
Post by Mike Epprecht (SQL MVP)
Post by Wayne Snyder
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
Post by Britney
Hi guys,
I know most of syntaxes should be be the same, such as select
statement, create table, drop table statement.
but I believe there should be some differences between them in
programming,
Post by Britney
I think sybase is more strict than MS SQL right?
Thanks
Brit
Loading...