Alter column in Single query

Sep 13 2010 2:45 AM
Hi all,

I am a logical issue. I want to alter the data type of  the some columns but to alter the data type of each column I will have to write the query number of times. for example


alter table ratesys_gc_cdr
alter column moderator_id varchar(10)

--
--
--

alter table ratesys_gc_cdr
alter column  n varchar(10)

So the my question is, can we make it in a single alter script?
I am using sqlserver 2005.



Answers (3)