Declare @Id Int                               
Select @Id = Id From sysobjects Where Name = 'Tbl_ClubH'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'SmsFlag')
  Alter Table dbo.Tbl_ClubH Add SmsFlag BIT DEFAULT(1) 

                             
Select @Id = Id From sysobjects Where Name = 'Tbl_ClubH'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Pass_club')
  Alter Table dbo.Tbl_ClubH Add Pass_club char(4)

