Can you guys please recommend a good sql books which mainly
concentrates on latest ansi standard. I do not want any vendor specific
sql books. I know later versions of Oracle supports ansi standard and I
want to learn ansi way of writing sql.

Howdy folks,
*HJELP!* While experimenting with the a relationship problem , I think I
might have fudged the database. I've set up a 1:1 relationship between
two tables, cascading updates and so on. Now I can't access anything

Could anyone help write an SQL statement to take this:
Table X (  key, Money, TheDate, first, last, ...) =
( 1, $1, #jan 4, 2006#, 'fred', 'willard', ...),
( 2, $4, #apr 1, 2006#, 'emanuel', 'lewis', ...),

Probably not a great idea, but is it possible to create a constraint on
an aggregate of rows? E.g. "sum(amount) = 0 group by foreign_key"
Any feedback appreciated,
Isak

I think the practice of exploitations of relation control systems for
control databases discovered considerable limitations into a relation
model of data presentation. Nowadays necessity has shown up to refuse
the relation mode and to pay attention to the undeservedly forgotten

hey all...
im looking to set up a p.o.s system in my shop, it's a grocery store.
After receiving quotations from three sources, they all spoke about
database. One had Microsoft SQL, the other had MySQL and the last

I have an old database app that is no longer supported.  It stored data
in tables in individual files.  Associated with each file is a .key
file.  Is there any way to determine what database format was used to
create the files so that I may begin the challenge of data conversion?

 I have a database with two tables
a) A table of 2 million records with city, zip and associated
information (say XYZ)  and
b) zipcode latitude, longitude table having  >40,000 records/zip codes

I was hoping someone could guide me to a database comparison site or
alternatively share their knowledge with me.
I am currently using Access but will soon need to change to something
that can handle larger amounts of data. SQL Server is an option but

Hello out there!  I have a client that has old legacy apps written in
FoxPro 2.5 for DOS running under Windows XP.  A lot of the screens need
maintenance/fixing before they can be revamped and eventually rewritten
in VFP 8.0.  It's been a while since I've touched FoxPro 2.6 for

How can I extract time value from a date column in oracle. For example,
I have a date column which stores date as 7/6/2006 1:21:00 PM.
I want the value 1:21:00 PM
Regards

Is there anything like Hibernate but for C++?
Thank you in advance!
Alessandro

I have a date column in one of the table in oracle. The date value
stored is:
7/5/2006 2:11:00 PM.
I would like time to be updated to 6PM so that the date value will look

Assume I have a table with only 1 row and all column is 'int'. I just
wonder is it possible to use SQL to check if any one of those column
contain a 'null' without knowing the column name?
For example,

I'm trying to determine the negation of A intersect B quicker than:
(A UNION B) MINUS (A INTERSECT B)
Is there a standard SQL operator that will do this?
Thanks