hello experts,
Do you know where I can get FREE ODBC driver for Sybase.
My client machine: XP
Sybase server: ASE 12.5
By the way, I've tried DataDirect but it is already expired (not FREE ...
Does Sybase have year() and month() functions for DATETIME type?
I am attempting to write a SQL script that will create a table if it does not exist already. THE TABLE CANNOT BE DROPPED AS PART OF THIS SCRIPT.
I coded this and it ALWAYS trys to create th...
Hi there,
i thought i'd get some advice and some sample code on how do go about selecting values from one table and inserting values into another table, i believe cursors or iteration will so...
select @v_CustUniqNum_1 =
case
when lcxr.SequenceNum = 1 then
ct.CustUniqNum
end,
@v_CustUniqNum_2 =
case
when lcxr.S...
Hi there,
i have created a temp table with one column. I want to iterate through the list of entries within this table and do some processing.
Here's my tsql, can someone tweak it so that...
hi,
i have date format in mm/dd/yy hh:mm:ss in my database.
for example a date field is presently looks like 01/04/99 12:00:00. but i want to convert the same datefield to 01/04/99 11:59:00....
Does anybody know where I can get a free powerbuilder tutorial? On-Line or download.
hi there,
relatively simple question i hope. Sybase database 'text' is running on server x, i have isql installed on my pc and on a unix server named y. How do i connect to sybase on server ...
Hi
We have two RDBMS backends for our product:
1) Sybase Adaptive Server 12.5.1
2) SQL Server 2000.
Both databases have the exacltly same script (apart from minor syntax changes) since ...
I have worked entirely with Oracle databases in the past, so I have used PLSQL Developer to access the database. I will now be working with a Sybase Version 12 database and I have no client so...
Please help me in calculating user database size in Sybase ASE 12.5.3.
If there are any scripts please pass me those.
Thanks a lot..
How do I get column names from table using SQL.
In SQL Server we use something like
SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = @tablename
Hi
Where do I get the tutorial for sybase sql server, I am completely new to this server, I don't even know how to execute the queries like
do we need to have a semi-colon at the end of...
Hi there,
just started with sybase. pls tell me how can I get a table's description in sybase?
I know in oracle "describe 'table name'; " does the job. how about sybase?
Hi,
I want to find out the list of all users in the database.
Please let me know how it should be done.
Also , what does suid mean in sysusers.
Thanks
Chitra.
Is it possible to limit the number of rows returned in a query?
If I use set rowcount 10, will it set the limit for just my connection ?
With MSSQL I can use select top n,
Than...
Hi ,
Is there a length function in Sybase which returns the length of the field. Thanks
Hi,
I want to create a table with an autoincrement field, with the following syntax:
CREATE TABLE auto1
( primary1 INTEGER NOT NULL DEFAULT AUTOINCREMENT,
data1 INTEGER NOT NULL,
P...
Obviously a newbie. Is there a way to grant select on all tables without having to run the grant statement for each table? I need to grand a user select access on all the tables in a databas...
I try to connect to a Sybase server from my machine.
When I do a direct connection from Java, I am able to connect to the Sybase server.
Also, when i configure it as a ODBC connection, ...
how would you go about getting the last_month_end_date in a sybase query?
I know oracle has something like last_day that i use to use. I also wanted to kno if there was a way of doing somethi...
There doesnt appear to be a REPLACE(str1,str2,str3) function in sybase. There must be an equivalent function to replace a string of chars (str2) with a new string of chars (str3) in a string (...
Hello Experts,
I need to copy the data from Table1 to Table2
INSERT INTO <Table2>
SELECT * FROM <Table1>
What will be the best way to do?? Insert into small batches? Table 1 contains...
I need to check if a table of an index already exists prior to DELETE command.
It should be something like IS_OBJECT() in MS SQL Server I guess.
Thanks.
