sybase
Detect if a table exists
In SQL Server you can write SQL to check if a table exists.How can I do that for ADS? I have a need t开发者_运维问答o write some Delphi code to say if table exists do this else this...The system proc[详细]
2023-03-19 01:24 分类:问答Stored procedure to java attributes
I have a bunch of Sybase SP\'s for CRUD operations that I need to create services for in the mid-tier layer.[详细]
2023-03-19 00:12 分类:问答SQL: Preserving order of return values
If I submit the following SQL statement to a database: SELECT setting_value FROM dba.system_settings WHERE setting_name = \'RequestWebServiceURL\'[详细]
2023-03-18 03:02 分类:问答DBI::Sybase data-conversion resulted in overflow
I am writing a Perl script that is using the DBI module and is connecting to a Sybase DB. I am calling a stored procedure (one that I don\'t have access to so I cannot post sample code) and when I get[详细]
2023-03-17 15:24 分类:问答sybase varchar to datetime
I have to take a string that has month, day, year, hour, min AM/PM and select from a table that has a datetime column.How canI do this?I have seen some examples of custom queries, but this seems a bit[详细]
2023-03-17 14:58 分类:问答Does Sybase support string types that it doesn't right trim?
The accepted answer to this question claims that using a cha开发者_如何转开发r column will preserve all filling spaces in a string in Sybase, but that is not the behavior I am seeing (unless I\'m mist[详细]
2023-03-17 06:02 分类:问答Sybase SQL union of two different tables
Is it possible to make a union from two tables with开发者_Go百科 different number of columns, values and column types in Sybase SQL?Sure, as long as the columns from the top and bottom part of the uni[详细]
2023-03-16 07:26 分类:问答How to debug transaction commit in sybase?
I have a transaction based application and it rolls the operation back on an error.However in some cases, the rollback doesn\'t happen. ( Though its getting called from the application). Ours is a ver[详细]
2023-03-15 11:31 分类:问答Sybase: Composing a WHERE for a timestamp datatype
I\'m trying to compose a SQL Select statement for Sybase with a Where clause on Timestamp datatype. 开发者_JAVA技巧[详细]
2023-03-14 16:48 分类:问答How to get all user defined datatypes in Sybase?
Could you 开发者_如何转开发please help me in finding all user defined datatypes in a sybase database.[详细]
2023-03-14 08:54 分类:问答
加载中,请稍侯......