I have 2 tables.
I have to compare whether the data in those 2 tables are same or not.
( For example : I have to find, how many records different between
those 2 tables, if those tables are almost similar)

I am learning Sybase, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only Sybase DBA.
You were just informed by the management that one of the Sybase

 I have one table named "table2".
I wanted to create one new table "table1" having the exact data
structure of "table1".
In Oracle we can do like,

28 September 2008: Recent updates at www.sypron.nl
--------------------------------------------------
This month's quiz question is about finding the
actual size of your raw devices...

INSERT INTO test_table (avail_seq) VALUES ((SELECT
COALESCE(MAX(avail_seq), 0) + 1 FROM test_table));
Whenever I run that SQL query, I get the following error:
The name 'avail_seq' is illegal in this context. Only constants,

I have the following doubts regarding update statistics.
1. I have updated the statistics of a particular table/index. Where
can i find the last date on which i have updated the statistics for a
particular table/index ?

The call for speakers for Data Services World Fall 2008 is open until
September 26, 2008. Data Services World is co-located with SOAWorld,
Cloud Computing Conference and Expo and Virtualization Conference in San
Jose, California.

hey all,
I was wondering if it was possible to do the following -
I would like to set a 'sync point' where
1) transactions could occur on a given database or databases after the

I'm using a new Solaris machine using the Niagara CPU. bcp seems to be
running much slower then other platforms. *much*  slower. A bcp on the
Niagara platform seems to take twice as long as an older Sparc CPU.
I'm using Sybase 12.5 and Solaris 10.

Is there a way to determine which stored proc / SQL ran on a given day
in Sybase?
Does Sybase maintain a log which have these information?
Thanks in advance,

We will update database on our office to version 15 very soon, but I
have some doubts about, maybe you could help me on that.
We have export/import procedures between many databases in our system,
some of them are customer side. Then this databases won't be upgraded.

Is there some SQL query you can perform to read the contents of a
stored procedure?