Thursday, February 23, 2017

Count Columns in Table in SQL Server

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

No comments:

What Happens to 401(k) When You Change Jobs

Understanding Your 401(k) Account Upon Job Change What is a 401(k) plan? A 401(k) plan is a workplace retirement savings account that al...