MSSQL help needed.... just 1 simple question.

[timot]

Hey guys, tried googling but couldnt find any.

I want to alter 2 columns in a table, how do i do that?

ALTER table_name ALTER COLUMN column_1 VARCHAR(##)

the code above only alters 1 column of the table right? how do i alter 2 columns of the same table?

 

[FP]

Probably two statements.

 

[timot]

has to be 2 different statements?

 

[TeamZero]

You'll have to just run two statements.

 

[timot]

ok thanks guys! !!

 

[JACKDRUID]

2 statements..

alter table x alter column x1 int
go
alter table y alter column y1 int
go