Top "Sybase" questions

How do I limit the amount of results returned in Sybase?

I need to query a Sybase database which has a lot of data in it, and would like to set …

sql limit sybase

list all tables from a database in syBase

In sql server 2012 i'm using USE myDatabase; GO SELECT * FROM sys.objects WHERE type = 'U'; Is it possible to do …

sybase sap-ase sap-iq

Sybase: get list of stored procedures using a particular table

I have 500 stored procedures in a Sybase database. Using SQL, can I get list of all stored procedures that are …

stored-procedures sybase

How to separate positive and negative numbers into their own columns?

I have a table with the following columns and data: activity_dt | activity_amt 2009-01-01 | -500 2009-01-01 | 750 Can …

sql sybase

How to connect Sybase database using Java code in NetBeans?

I want to connect remote Sybase from my Java code written in NetBeans. So far I have prepared a code …

java jdbc connection sybase

How do Ilist tables based on column name in sybase?

How do I list all the tables in a database that contain a column with a given name?

sybase

What is the mysterious 'timestamp' datatype in Sybase?

I recently discovered a table in our Sybase database at work that uses a column of a type 'timestamp'. If …

sql sybase

How to change existing column type of a table in Sybase?

I searched for a while and can't get an answer. Why this doesn't work? ALTER TABLE mytable ALTER COLUMN price …

sybase alter-table

SQL SELECT INSERT INTO Generate Unique Id

I'm attempting to select a table of data and insert this data into another file with similar column names (it's …

sql database select insert sybase

How to get sybase table column name and its datatype and order by?

There are multiple table in my sybase database. I want to know the column name and datatype of a given …

database sybase