Posts from ‘July, 2011’
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
(<column list>)
SELECT <column list> 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 a list [...]
