• I use the following easy-to-memorize SQL to get column lists:

    select ', ' + name from syscolumns where id = object_id( 'MyTable' ) order by colorder

    or

    select ', ' + column_name from information_schema.columns where table_name = 'MyTable' order by ordinal_position