Adding more than one column in sql server

[MyronCope]

I am trying to write a script to insert more than one column but the script I am making only inserts the column in the second line and I dont know why. In my code below, columnB is added to the table, but not columnA. I am stumpedMy sql is:

Alter table  [dbName].[dbo].[tableName] Add columnA bit Default 0 Not NullAlter table  [dbName].[dbo].[tableName] Add columnB bit Default 0 Not Null

thanks for your help.

Edited May 30, 2006 by aspnetguy

[dooberry]

You don't need to write the ALTER table statement twice, you can separate the fields with commas:

ALTER TABLE dbname.dbo.tablenameADD columnA bit Default 0 Not Null, columnB bit Default 0 Not Null