Alter statement

Hi All,
Can I use one alter statement to change 2 columns' datatype.
Or Is there any command that I can use to change 2 columns' datatype.
For example : I have the table tableA as below
create table tablea (ca smallint not null, cb smallint not null)
and I want to change to int not null for both coHi Jodie,
You only get one ALTER COLUMN statement per ALTER TABLE statement:
ALTER TABLE tablea ALTER COLUMN ca int NOT NULL
ALTER TABLE tablea ALTER COLUMN cb int NOT NULL
Books-Online ALTER TABLE: http://msdn2.microsoft.com/en-us/library/ms190273.aspx
Thanks,
Ken
On Feb 16, 6:49 pm, Jodie <J...@.discussions.microsoft.com> wrote:
> Hi All,
> Can I use one alter statement to change 2 columns' datatype.
> Or Is there any command that I can use to change 2 columns' datatype.
> For example : I have the table tableA as below
> create table tablea (ca smallint not null, cb smallint not null)
> and I want to change to int not null for both co