23.06.2013

SQL: Check column existance

To check column existance in MS SQL you can do the following:
SELECT * 
FROM [INFORMATION_SCHEMA].[COLUMNS] 
WHERE TABLE_NAME = @TableName AND COLUMN_NAME = @ColumnName

Комментариев нет:

Отправить комментарий