How do I add a BIT type column to a table? Alter table doesn't allow it? help!;)
This is a second login as I've forgotten my password and my old email address isn't valid anymore. but I will end...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10216547.html
When you use IE5 and visit a web site that is down, for example, IE5 will display a page entitled "Cannot find server" and go on to say that the page cannot be displayed.
This page is a system p...
http://www.experts-exchange.com/Software/Internet_Email/Web_Browsers/Q_10219660.html
Zones:
Web BrowsersDate Answered: 01/11/2000 Grade: C Views: 0
Is there anyway to alter a fields field size and format using vb code? I'm currently importing in an Oracle table into MS Access 2000. When I import the table I want to alter some of the fields f...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20496781.html
Zones:
MS AccessDate Answered: 12/12/2003 Grade: A Views: 0
Dear All,
I want change the FIELD Size in Ms Acces table through VB program with DAO. I use the follwing statement its working fine. If the field name having space (like Example Emp Nam...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20518396.html
Zones:
DatabasesDate Answered: 02/18/2003 Grade: A Views: 0
I want to alter an access 97 table using SQL. I need to modify the properties of a field to remove the 'required' property , or allow null values to be entered.
I have tried ALTER TABLE X DROP CON...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20827312.html
Zones:
MS AccessDate Answered: 12/17/2003 Grade: A Views: 0
This has to be something very simple.
I wrote this script to drop certain columns from tables instead of manually doing it one at a time.
Server: Msg 170, Level 15, State 1, Line 22
Line 22:...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21105729.html
Are there any apps out there that greatly ease the pain of altering column data types, column names, primary keys, etc. in tables? We find ourselves having to drop and recreate tables all of the ti...
http://www.experts-exchange.com/Database/DB2/Q_21326455.html
Zones:
DB2Date Answered: 02/24/2005 Grade: B Views: 0
1. I need to replace contents in the column [TransactionAmount] for all records in a table to (TransactionAmount*100) because these values were/are imported from a txt file via DTS.
Ex: Currently ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21456193.html
I want to use my ASP pages to rename the columns in newly inserted tables in my SQL Server 2000 DB. I looked it up and the syntax seems to be:
ALTER TABLE tblName RENAME COLUMN ColumnOldName TO ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21546814.html
Probs an easy one for you experts, how can i make each <tr> a different colour, i.e red-white-red-white.....
?
This is my output table from a cf query....
<table border ="3">
<cfou...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/HTML/Q_21645133.ht...
Zones:
HTMLDate Answered: 12/05/2005 Grade: A Views: 0
