Alter table add multiple columns ms sql

Question

Can anyone tell me where is the mistake in the following query  ALTER TABLE Countries ADD    HasPhotoInReadyStorage  bit   HasPhotoInWorkStorage  bit   HasPhotoInMaterialStorage bit   HasText  bit    ALTER TABLE Regions ADD   HasPhotoInReadyStorage  bit   HasPhotoInWorkStorage  bit   HasPhotoInMaterialStorage bit  HasText  bit    ALTER TABLE Provinces ADD   HasPhotoInReadyStorage  bit   HasPhotoInWorkStorage  bit   HasPhotoInMaterialStorage bit  HasText  bit     ALTER TABLE Cities ADD   HasPhotoInReadyStorage  bit   HasPhotoInWorkStorage  bit   HasPhotoInMaterialStorage bit  HasText  bit    Alter table Hotels Add     HasPhotoInReadyStorage  bit   HasPhotoInWorkStorage  bit   HasPhotoInMaterialStorage bit   HasHotelPhotoInReadyStorage  bit   HasHotelPhotoInWorkStorage  bit   HasHotelPhotoInMaterialStorage bit   HasReporterData  bit   HasMovieInReadyStorage  bit   HasMovieInWorkStorage  bit   HasMovieInMaterialStorage bit      I get the following errors   Msg 102  Level 15  State 1  Line 2 Incorrect syntax near      Msg 102  Level 15  State 1  Line 9 Incorrect syntax near      Msg 102  Level 15  State 1  Line 15 Incorrect syntax near      Msg 102  Level 15  State 1  Line 22 Incorrect syntax near      Msg 102  Level 15  State 1  Line 29 Incorrect syntax near

User · Answer

Alter table Hotels  Add       HasPhotoInReadyStorage  bit    HasPhotoInWorkStorage  bit    HasPhotoInMaterialStorage bit    HasHotelPhotoInReadyStorage  bit    HasHotelPhotoInWorkStorage  bit    HasHotelPhotoInMaterialStorage bit    HasReporterData  bit    HasMovieInReadyStorage  bit    HasMovieInWorkStorage  bit    HasMovieInMaterialStorage bit        Above you are using        Also  you are missing commas   ALTER TABLE Regions  ADD   HasPhotoInReadyStorage  bit    HasPhotoInWorkStorage  bit    HasPhotoInMaterialStorage bit  lt      comma needed here  HasText  bit      You need to remove the brackets and make sure all columns have a comma where necessary

User · Answer

You need to remove the brackets  ALTER TABLE Countries ADD   HasPhotoInReadyStorage  bit   HasPhotoInWorkStorage  bit   HasPhotoInMaterialStorage bit   HasText  bit

User · Answer

ALTER TABLE Regions ADD   HasPhotoInReadyStorage  bit       HasPhotoInWorkStorage  bit       HasPhotoInMaterialStorage bit   Missing          HasText  bit

User · Answer

Take out the parentheses and the curly braces  neither are required when adding columns

User · Answer

this should work in T-SQL  ALTER TABLE Countries  ADD HasPhotoInReadyStorage  bit    HasPhotoInWorkStorage  bit    HasPhotoInMaterialStorage bit    HasText  bit GO   http   msdn microsoft com en-us library ms190273 SQL 90  aspx

User · Answer

Can with defaulth value  T-SQL   ALTER TABLE     Regions ADD     HasPhotoInReadyStorage BIT NULL  --this column is nullable     HasPhotoInWorkStorage BIT NOT NULL  --this column is not nullable     HasPhotoInMaterialStorage BIT NOT NULL DEFAULT 0  --this column default value is false GO

[sql-server-2005] Alter table add multiple columns ms sql

Examples related to sql-server-2005