开发者

Sybase Features

Does anybody know if Common Table Expressions and User-defined functions (not from Java) are supported on Syba开发者_开发百科se 12.5? I'm trying but could not seem to make these work. Thanks guys.


Both are not supported by ASE 12.5


You can use stored procedure instead of functions. I am not sure about what you are referring to by saying common table expressions


Sorry I have to disagree. Microsoft SQL Server is based on Sybase 7.0. So there may not be Common Table Expressions and User-Defined Functions, there are equivalent ways to do the same thing.

For example CTE can be done either in nested queries or via temp tables using a number sign (#) in front of the table name.

For User Defined Functions, create a stored procedure with simple SQL code and call it via the exec function for example "exec my_sql_code". This allows nesting of stored procedures.

Good SQL, good night.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜