原來SELECT INTO也可建表格

SELECT ‘1’AS [column_1] into [T2] from [T1]

以前一直都沒有這樣用，我只會笨笨的先CREAT TABLE再

INSERT INTO [T2] (column_1) SELECT column_1 FROM  [T1]