CREATE Proc Test@TableName varchar(200)asselect stuff((SELECT ','+COLUMN_NAME + '' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName for XML path ('')),1,1,'') as ColumnNames
Login to post response