How to alter more than one existing columns in SQL 2000 Server?
I m working in SQL Server(2000) Enterprise Edition.When I m using "Alter Table <tablename> Alter Column <column name> (column definition)" for only 1 column then its working (using Query Analyzer). However when I m trying to alter more than 1 column, Query Analyzer is giving error messages (syntax error).Pls suggest ways.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 14, 2004 7:05 AM
UPDATED:
September 14, 2004 12:18 PM
Answer Wiki:
this syntax gives me no errors in query analyzer:
ALTER TABLE school ADD U int
ALTER TABLE school ADD M int
To see all answers submitted to the Answer Wiki: View Answer History.
/*—————————–
ALTER TABLE school ALTER COLUMN UMs nvarchar(30);
ALTER TABLE school ALTER COLUMN Members nvarchar(30);
—————————–*/
(1170 row(s) affected)
(1170 row(s) affected)