Link to home
Start Free TrialLog in
Avatar of crishna1
crishna1Flag for United States of America

asked on

Adding multiple columns to a table

is there a way to add multiple columns to a table with one alter statement? does Sql Server even support such?
ASKER CERTIFIED SOLUTION
Avatar of bwdowhan
bwdowhan

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bwdowhan
bwdowhan

oops... the last line should be [field3] [int] NULL

I mistype the closing square bracket as a closing curly bracket.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of crishna1

ASKER

is this a new feature in 2005 or has it been there always? i thought Sql Server did'nt allow that earlier, i might be wrong.
SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial