ALTER PROCEDURE [dbo].[GetCountOfColumnToTable] @DBNAME NVARCHAR(50),@TBLNAME NVARCHAR(50) AS BEGIN declare @TotalColumns int = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = @DBNAME AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME = @TBLNAME) declare @CountColumns int =@TotalColumns WHILE @CountColumns <= @TotalColumns BEGIN SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = @DBNAME AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME = @TBLNAME SET @CountColumns = @CountColumns + 1 END END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)