View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 04:05 PM
Brian Ceccarelli
 
Posts: n/a
Default Re: Where do Sybase & MS SQLServer Differ?

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



Reply With Quote