Hugo Kornelis (11/29/2011)

---

Here's the way I write INSERT statements, to make it easier to say which expression in the SELECT list matches which column in the INSERT list:

INSERT INTO #ATable

(col1, col2, col3)

SELECT 2, 1, 3;

(Where I change the column positions based on the length of the column names and expressions in the SELECT list).

I usually limit myself to three columns per line, because I don't like to scroll horizontally. So when there's a long column list, I use this style:

INSERT INTO #BTable

(col1, col2, col3,

col4, col5, col6,

col7, col8)

SELECT 2, 1, 3,

4, 5, 6,

7, 8;