I want to drop a table only if it exists (avoid the 'table doesn't exist' error) -- is there any way to do a conditional drop?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10026501.html
Hello all
I would llike you to help me normalize the tables.
Supposed I have 2 tables. First table is called "Job". Table "Job" has "Job ID" as primary key. And the left 3 fields are ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10033158.html
Zones:
MS AccessDate Answered: 12/18/1997 Grade: A Views: 0
How do I use the 'INSERT' or 'SELECT' SQL to copy all records from one table to another table, assuming the two tables have the same schema and I have all the privileges?
http://www.experts-exchange.com/Database/Oracle/Q_10035592.html
Zones:
OracleDate Answered: 01/13/1998 Grade: B Views: 5
I have a database with a very large table. It is in its own mdb file, which is now just over 900MB, and growing at about 30MB per week. According to the User's Guide, the maximum table size is 1GB....
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10037725.html
Zones:
MS AccessDate Answered: 02/03/1998 Grade: B Views: 0
It is a typical 3-tier enviroment.
There are 3 PCs on the lan :
PC1. a win95 client having a web browser
PC2. a winnt 4 (pdc server or just server) having IIS 3, *.asp, odbc driver (to read datab...
http://www.experts-exchange.com/Web_Development/Authoring/Q_10044094.html
Zones:
AuthoringDate Answered: 04/30/1998 Grade: C Views: 0
Hi!
I have working with a database, where are some tables.
The first table contain the names of the another tables, this
is growing in time. When I begin to work with the dbase, I know only th...
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_10077684.htm...
Zones:
Windows MFCDate Answered: 09/03/1998 Grade: B Views: 0
As an overview VB5.0, user can select anyfile from directory and import into any access DB. a listbox will be filled up with the table names. They can import this file into one of the previous ta...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10083292.html
Zones:
Visual BasicDate Answered: 10/29/1998 Grade: C Views: 0
I have a table with a string field which is 6 characters in length. I want to change it to ten characters.
I need to do this at run time, so please don't suggest using Database Desktop!
Thanks.
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10086471.html
I don't know if something is wrong with my browser or if it is the code! I'm only creating a table that contains other tables that all hold images! The problem is in IE 4 everything is seemless but...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/HTML/Q_10093014.ht...
Zones:
HTMLDate Answered: 10/28/1998 Grade: A Views: 0
Hi! I'm trying to create a table and I don't want to define a key but if I do that, I cannot update the table from my VB application.
The table is supposed to serve as an auditing table so I writ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10094398.html
