Declare @column_name varchar(50);
Set @column_name = N'Description';
If Exists(Select * From Sys.Columns Where Name = @column_name AND Object_Id = Object_Id(N'Employees'))
Begin
Print 'Column Name ' + @column_name + ' Exists';
End
Else
Print 'Column Name ' + @column_name + ' Does Not Exist';