MSSQL ~ INSERT with SELECT

SELECT Query
SELECT a, b ,c FROM Table

INSERT
INSERT INTO Table2(a, b, c)

INSERT with SELECT query~

INSERT INTO Table2(a, b, c)

SELECT a, b ,c FROM Table

http://www.1keydata.com/tw/sql/sqlinsert.html