Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
CREATE Proc Test @TableName varchar(200) as select stuff((SELECT ','+COLUMN_NAME + '' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName for XML path ('')),1,1,'') as ColumnNames
Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com
sriram
Login to post response