Microsoft have added some new system procedures and functions since
their divorce.

Pete.





You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

Steve wrote:

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

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 (AT) yahoo (DOT) com> wrote