用命令方式查看Sybase数据库版本
C:\Documents and Settings\feng>isql -SFZB -Usa -P1> select @@version2> go --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Adaptive Server Enterprise/12.5.1/EBF 11522/P/NT (IX86)/OS 4.0/ase1251/1824/32- bit/OPT/Mon Sep 29 21:41:30 2003(1 row affected)1> quitC:\Documents and Settings\feng>不支持：select convert(varchar(24),getdate(),123)，日期格式“123”返回2010/23/03 13:55:35
不支持：关键字top：select top 10 * from tablename ,在通过设置：set rowcount 10，再执行SQL
页:
[1]