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:

How to Deploy Apps on Google Cloud: A Step-by-Step Guide for US Business Owners

Introduction to App Deployment on Google Cloud Deploying applications on cloud platforms has become a fundamental practice for businesses...