sap-ase
Constructing dynamic columns from parameters in Sybase
I\'m trying to write a stored proc (SP) in Sybase. The SP takes 5 varchar parameters. Based on the parameters passed, I want to construct the column names to be selected from a particular table.[详细]
2022-12-23 11:04 分类:问答problem sybase autogenerated ids
I have a table in which the PK column Id of type bigint and it is populated automatically increasing order of 1,2,3...so on[详细]
2022-12-21 23:01 分类:问答Selecting max/min value from more than one fields
In the开发者_JS百科 following query the start/finish columns are datetime fields. How should I modify this query to get two more columns, one with the min date and one with the max date (of all the[详细]
2022-12-21 20:39 分类:问答Msg 3151: the database that was dumped was not quiescent when the dump was performed
I am working on loading database dumps to a new ASE server, but when I try to load 15gb and 32gb dumps to a database, I get the below error:[详细]
2022-12-21 07:42 分类:问答ASE Sybase BLOB
hi I want to write a file into a column of a blob 开发者_开发知识库data type,can some one pls send me the syntax for it. Appreciate if you could also send me the syntax for retrieving the file while d[详细]
2022-12-20 03:24 分类:问答How to INSERT INTO table DEFAULT VALUES
When you want to insert default values into a table, some databases allow this syntax: INSERT INTO table DEFAULT VALUES;[详细]
2022-12-19 03:19 分类:问答Sybase Internal Error 30016
Database server is migrated from version 12.5xto version 15.03 Sybase.Data.AseClientversion - 1.15.50.0[详细]
2022-12-14 07:43 分类:问答Am I opening and closing my ODBC connection incorrectly?
When connecting to a Sybase ASE database via ODBC using the code below, I\'ll occasionally get a \'[IM006] [Microsoft][ODBC Driver Manager] Driver\'s SQLSetConnectAttr failed\' error.[详细]
2022-12-13 12:03 分类:问答Configuring SQL Anywhere to read from an ASE server
I have a Sybase ASE server that I\'m able to connect to with ASE iSql totally fine. The database definition in my sql.ini file looks like:[详细]
2022-12-12 06:06 分类:问答Sybase 15 performance issue
I am working with Sybase 15 in my application and there is performance issue related with nested joins. I have stored procedure which selects 2 columns from 2 tables and compares equalities of over 10[详细]
2022-12-08 19:47 分类:问答