How To Append A Header Row In SELECT

Hi All,





When calling my SELECT statement, I would like to have Column name and Data type as the first record. Is this possible to do?


I would like to make a SP that would select all data from any table(with a header row) with just:





_sp_getData ' table_name'





I looked at sysobjects, and syscolumns tables, but was unable to put it all together. I have over 200+ tables, so creating variables for every column is very cumbersome.





Something like this:





select 0 AS SortCol ,


cast(min(case ordinal_position when 1 then column_name end) as varchar) as col1,


cast(min(case ordinal_position when 2 then column_name end) as varchar) as col2,


cast(min(case ordinal_position when 3 then column_name end) as varchar) as col3,


cast(min(case ordinal_position when 4 then column_name end) as varchar) as col4,


cast(min(case ordinal_position when 5 then column_name end) as varchar) as col5,


cast(min(case ordinal_position when 6 then column_name end) as varchar) as col6,


cast(min(case ordinal_position when 7 then column_name end) as varchar) as col7,


cast(min(case ordinal_position when 8 then column_name end) as varchar) as col8,


cast(min(case ordinal_position when 9 then column_name end) as varchar) as col9


from information_schema.columns where table_name = 'authors'


union all


select 1 , au_id, au_lname, au_fname, phone, address, city, state, zip,


cast(contract as varchar)


from authors








Is not an option.








Thank you very much in advance,


Vla Orlovsky