Get a comma-delimited list of columns

One of the things I've been doing recently has been writing lots of SQL inserts in which I've had to specify the columns. For example: INSERT INTO tblMyTable () SELECT FROM tblMySourceTable The most tedious part was writing the column names in a comma-separated list. It would be good if I could automagically create... More