There are minor differences between the syntax of MS SQL and Sybase SQL.
Here are a couple:
1. Sybase can take parameters in print statements:
print 'Hello !1%", 'World'
Microsoft cannot take parameters in a print statement.. MS uses the print
statement from v4.x of Sybase.
2. There are minor differences in using cursors. You must declare a
cursor in its own batch in Sybase. In MS, the declare cursor can be one
of many statements in a batch. There are also small cursor syntax
differences @@sqlstatus vs @@fetch_status, close cursor X vx close X.
MS and Sybase do diverge on the stored procedures, but there are still many
common ones: sp_who, sp_help, sp_addlogin, etc. The system tables share
a lot in common, but they do vary.
..
Brian
http://www.dbpowersuite.com
"Steve" <stevesusenet@yahoo.com> wrote in message
news:6f8cb8c9.0311140309.3b064c16@posting.google.c om...
> I would like to use sybase on linux at home to learn more TSQL for
> SQLServer at work.
>
> I was wondering where the differences were between sybase and
> sqlserver.
>
> Thanks in advance for any info
>
> Steve