Judge whether a column exists in a table

if not exists( select 1 from dbo.syscolumns s
where name ='yourColumn'
and id = object_id(N'YourTable'))
begin
alter table YourTable add yourColumn ColumnType
end