To check if a column exists in a SQL Server table, you can use the INFORMATION_SCHEMA.COLUMNS system view, which provides information about all columns in all tables in a database. Here’s a SQL query that checks if a specific column exists in a specific table:

IF EXISTS (
    SELECT 1 
    FROM INFORMATION_SCHEMA.COLUMNS 
    WHERE TABLE_NAME = 'YourTableName' 
    AND COLUMN_NAME = 'YourColumnName'
)
BEGIN
    PRINT 'Column exists in the table.'
END
ELSE
BEGIN
    PRINT 'Column does not exist in the table.'
END

Replace YourTableName with the name of your table and YourColumnName with the name of the column you are checking for. This query will print a message indicating whether the column exists in the specified table.

This approach is widely used because it works across different versions of SQL Server and is easy to read and understand.