SQL Server 捉回一個table的欄位數量

SELECT COUNT(*) AS 'NumOfFields'
FROM syscolumns
WHERE [id] IN (SELECT id FROM sysobjects WHERE [name] = 'table_name')

將 table_name 改為你的 table名稱