I found another bug with an easy win:

Columns that include spaces need to be enclosed in square brackets.

DECLARE @ALLcolumns TABLE (idcol1 INT IDENTITY,colname VARCHAR(100))

INSERT INTO @ALLcolumns (colname)SELECT...