Sybase
关注
分享
扫一扫
iteye_5554
这个作者很懒，什么都没留下…
展开
-
Sybase Query Plan
To see query plans, use:set showplan on To stop displaying query plans, use:set showplan off原创 2009-03-20 16:28:44 · 118 阅读 · 0 评论 -
Sybase tricky sql -- How to delete the earliest 2 records?
Table: create table BE_TES_FEED ( TRADE_STATUS VARCHAR(1) NOT NULL ,INSERT_DATE DATETIME NOT NULL) lock datarowsgo Data: INSERT INTO BE_TES_FEED VALUES ('1', getDate())IN...原创 2009-07-02 17:55:55 · 102 阅读 · 0 评论 -
sybase procedures and cursors
How to view stored procedure spec? sp_help ${stored_procedure_name} How to view the source of stored procedure? sp_helptext ${stored_procedure_name} Super simple procedure example...原创 2009-07-24 17:47:06 · 124 阅读 · 0 评论