Top "Sybase" questions

Convert INT to VARCHAR SQL

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type …

sql select type-conversion sybase

Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

I have the below error when I execute the following script. What is the error about, and how it can …

sql sql-server sybase

From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given …

sql metadata sybase sap-ase isql

Difference between drop table and truncate table?

I have some tables that I build as a part of my report rollup. I don't need them afterwards at …

sql sql-server sybase

How to convert a string to a date in sybase

I need to specify a date value in a sybase where clause. For example: select * from data where dateVal < […

sybase type-conversion

How to list all the user tables in Sybase along with their row count?

I would like to return all the tables and its count next to it. what is the quickest way to …

sybase

Getdate(), -1 day

I do not understand why, but somehow this query doesn't work. I want to take system date -1 day where …

sql sybase sqlanywhere

Get records from last hour

I have this query: SELECT Field1, OrderFor, Writeback, Actshipdate, Orderstatus, receivedate, receivetime FROM orderinfo, shippinginfo WHERE orderinfo.orderid = shippinginfo.orderid …

sql sybase sybase-asa

Execute stored proc with OPENQUERY

I have SQL Server 2008 with a linked Sybase server and I am trying to execute a stored procedure on the …

sql sql-server tsql sybase openquery

Sybase date comparison - Correct format?

I'm pretty new to Sybase and am writing a query to return results after a specified date, and also before …

sql database sybase mybatis