Spaltenanzahl einer Datenbanktabelle auslesen:
SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = 'databasename' AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'tablename'
Spaltenanzahl einer Datenbanktabelle auslesen:
SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = 'databasename' AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'tablename'