|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 9th, 2003, 05:39 PM
|
|||
|
|||
|
Error In Alter Table Statement....
Hi, can someone with a little more experience help me with this statement:
ALTER TABLE Items (ADD COLUMN File_ID INTEGER, ADD COLUMN Retail_Price MONEY, ADD COLUMN Item_Weight INTEGER, ADD COLUMN Item_Max INTEGER, ADD COLUMN Item_Stock INTEGER, ADD COLUMN Item_Related TEXT(255)); error:Syntax error in ALTER TABLE statement. What am I doing wrong... is it not possible to add more then 1 column per query? Your help is much appreciated. -pb
|
|
#2
October 11th, 2003, 01:13 PM
|
|||
|
|||
|
PS I'm pretty sure I answered my own question. It semms to not be possible to add more then 1 column per query so I broke the statement up.
|
|
| Viewing: ASP Free Forums > Database > SQL Development > Error In Alter Table Statement.... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
