Re: No support for CASE keyword??

It seems that sybase ASE 11.5 CASE and MS-SQLServer 6.0 CASE statement is exactly the same. Am I right?

On Sat, 20 Jun 1998, Andrew Prosser wrote:
>
> DCMessier wrote in message
> <1998062003334400.XAA29240_at_ladder03.news.aol.com>...
> >I am responsible for a databsae maintenance application. We have a
 front-end
> >developed in VB 5 which uses stored procedures for all data access. We
 support
> >(at the present time) Microsoft SQL Server and Sybase SQL Server on the
> >back-end.
> >I was quite disappointed to learn today, while attempting to wrap-up
 testing of
> >our current release, that Sybase Transact-SQL does NOT support the ANSI
 SQL-92
> >standard CASE expression. Does anyone know WHY??
> >I was very upset, and wasted lots of time coming up with a work-around for
 this
> >untimely mess. Am I missing something here? Or is the only alternative to
 use
> >a complicated if..else construct?
> >It's frustrating to do primary development on MS SQL Server, with the
> >expectation that Sybase will support STANDARD SQL syntax.
> >Any suggestions out there?
 

> Transact-SQL did not support this originally, Microsoft included it in 6.0
> and Sybase has included it in 11.5, presumably you are using a lower Sybase
> version, if you were using MS SQL Server 4.2 it would not work either, so it
> depends what you call 'standard' T-SQL, as they are now different products
> it seems foolhardy to develop on MS and run production on Sybase. It will
> only get worse once 7.0 comes along, but then its your choice, cursor
> behaviour must also be interesting if you are using some of the MS features
> and new functions like isdate and isnumeric.
Received on Wed Jun 24 1998 - 00:00:00 CDT