How to get the Column list in sql srever

Hi ,


Try this ,You will get the Solution...........

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TableName' AND COLUMN_NAME not in('ColumnName1','ColumnName2')