use pubs
go
SELECT stmt
FROM (
        SELECT -1 AS pos, 'SELECT' AS stmt
        UNION ALL
        SELECT ORDINAL_POSITION,
                CHAR(9) + COL_NAME(OBJECT_ID('authors'), ORDINAL_POSITION) +
                CASE WHEN ORDINAL_POSITION < 4 THEN ',' ELSE '' END
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE TABLE_NAME = 'authors' AND ORDINAL_POSITION < 5
        UNION ALL
        SELECT 5, 'FROM authors'
) AS st
ORDER BY pos

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