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 [...]

Powered by WordPress

Website design adapted from WordPress theme PrimePress