August 31, 2006 at 6:03 am
I have a project in which I need to process some data that is in a Sybase database. I know SQL Server well, but not Sybase.
My boss does not want to create another instance of the data and so said write the stored procedure in Sybase.
I was wondering, is there a way to query against the Sybase Tables using T-SQL? That way I don't have to create another instance of the data in SQL Server but can still use SQL Server T-SQL.
I searched the interent last night for an hour and really didn't see any articles on writing Sybase SQL and I really don't want to write a Sybase stored procedure if I can help it.
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
August 31, 2006 at 6:58 am
August 31, 2006 at 7:00 am
Sybase uses a different dialect of T-SQL. There is some documentation at:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug
September 1, 2006 at 11:29 am
Sybase and SQL Server were once the same beast - I mean absolutely identical - just different labels (Sybase 4.9.2 and SQL v4.21). At present you could call them different dialects of T-SQL. Kind of like Cantonese and Mandarin are dialects of Chinese. First some system variables (@@'s) are different. If you are just writing develpment T-SQL you should notice almost no difference at all. except for a few builtin functions. Now when writing SPs, again it's almost identical. However you'll find cursor related commands slightly different.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply