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.
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
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
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:
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
When you want to insert default values into a table, some databases allow this syntax: INSERT INTO table DEFAULT VALUES;
Database server is migrated from version 12.5xto version 15.03 Sybase.Data.AseClientversion - 1.15.50.0
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.
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:
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