my aim is to modify the two fields to change its data type. BUt when im trying to run this command in the query analyzer, itsays "incorrect syntax error '(' "
hi KH! Thanks for the reply but what i'm trying to do is to modify 2 columns in one alter table statement...
I know if i used the alter column command, i can only alter 1 column at a time...but what im trying to do is to alter 2 columns at the same time...do you know any code where i can alter 2 columns at one alter table statement?
ALTER TABLE MODIFY
Posted - 01/19/2006 : 21:53:14
