sap-ase
sp_helpdb doesn't return all columns
W开发者_运维百科hen I run sp_helpdb dbname in Sybase Adaptive Server Enterprise, it returns only the following columns:[详细]
2023-01-22 22:25 分类:问答How do I get Sybase File Path, Transaction Log, & installation details?
I need to Retirve the following Details using Sybase SQL Query. 开发者_JAVA技巧1) Database Data File Path[详细]
2023-01-22 17:50 分类:问答Sybase SP result into Temp Table
HI, I have a SP which returning more than 100 fields with 1000+ row. I need to to save all in temp table and and rum my customize query to get the appropriate data.[详细]
2023-01-22 14:25 分类:问答Sybase 15 substring error in a case statement on update
Running on Adaptive Server Enterprise/15.0.3/EBF 17157 ESD#3/P/x86_64/Enterprise Linux/ase1503/2726/64-bit/FBO/[详细]
2023-01-20 14:29 分类:问答SYSBASE CONNECTIONSTRING
Iwant to connect Sybase 12.5 using vb 6.0, then what should be provider i开发者_C百科 can use to connect the Sybase 12.5. I \'m not familiar with Sybase. I would, however, suggest the following site:[详细]
2023-01-18 22:01 分类:问答Selectively deleting large amounts data from Sybase table
Using Sybase ASE 15 for this - I have about a large amount of rows (up to 10 mil) to delete from a table on a regular basis, but I want to keep a selection of the latest added data to the table, so th[详细]
2023-01-15 21:04 分类:问答Indexed Views in Sybase
Is it possible to create indices on views in Sybase (> ASE 开发者_高级运维12.5)?You can\'t create index on views becauce view is not a physical entitity. its just a view defination(sql query) execute[详细]
2023-01-14 21:40 分类:问答SybaseHelper class?
I am trying to connect to sybase ASE 15 and call a SP that does some DML. I was wondering if anyone has any pointers to a sybase helper 开发者_开发技巧class analogous to SQLhelper.cs or if someone has[详细]
2023-01-14 12:08 分类:问答How to determine how much disc space a table is using in ASE
I have 开发者_JAVA百科a table which I think might be better off if it uses different data types for many of the columns. I wish to design some tests to determine the pay off in disc space if these col[详细]
2023-01-08 06:10 分类:问答Update on row for each group with max value in other column
I have to update a column in a very, very large table. So performance is a big issue. The question is the similar to this one, but only for Sybase Adaptive Server Enterprise (ASE 12.5.4) plus I need[详细]
2023-01-06 21:52 分类:问答