-- To export data with a header row 
-- (Note datatype for all columns should be varchar b'cos of the header)
use pubs
go
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
order by SortCol

This page was last updated on May 01, 2006 04:28 PM.