Search results for query: *

I have had responsibility thrust upon me for three apps which will all use sql server ..... One will exist partially outside of our private network in a DMZ the other two will be on our private network. All three will access databases on the same machine inside of the private network. I am...

Following this question is a watered down version of the program that I am trying to write. I get an invalid sql statement error during the parse portion, the statement is valid, is there some other bit of voodoo, that I do not know that is causing this. If anyone can shed some light, I will be...

I want to write a program that will connect to, read from and update an oracle 9i database. The functionality i need to create is something along the following lines of seudo code. I need to know what libs I need, where to get them, and the basics of how to use them. If anyone can point me in...

Does anyone know the meaning of an error 1242, or 204. More importantly, is there a command ( either sqlplus or cmd line ) to describe an error based on it's number.

I managed to export the structures and data from one tablespace in my Oracle 8 database and I want to bring it into an Oracle 9i database.....I open up the Enterprise Management Tool ( IMP & EXP do not work in the Win 2K distribution ) but it tells me, when I get to the import and export menus...

Here is what I think I can, and hope to do.... I would like to dump all of the data in a tablespace as well as the table structures and key structures to a script file that I can then run on a 9i database in another tablespace where the tables would be recreated as well as primary and foreign...

If you are going to work with MySQL the book "MySQL" by Paul DuBois is, in my humble opinion, indispensable. It is written in a bare bones way that is easy to understand and extremely informative. This is not MySQL for dummies so some basic knowledge of at least standard SQL syntax...

Is there a way to have a date type column default to the current date without using time stamp. The reason is that I want to store the creation date of a record, but I do not want that date to change on subsequent updates. I have tried to do this using both CURRENT_DATE and curdate() to no avail.