Saturday, January 4, 2014

Count Column in SQLServer by sql statement

SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_CATALOG = 'CB201312' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'Main_CSV_DEL_ERROR_TOUAT_2'