Add a column to a table unless it already exists


if not exists (select * from syscolumns
where id=object_id('Employees') and name='MaidenName')
alter table Employees add MaidenName varchar(64) NULL