It’s me

February 25, 2009

SELECT * INTO {TARGET} FROM {SOURCE}

Filed under: SQL SERVER — rothmans @ 1:29 pm

- 새로운 테이블 생성, 전체 컬럼 INSERT
SELECT * INTO {TARGET} FROM {SOURCE}

- 새로운 테이블 생성, 일부 컬럼 INSERT
SELECT * INTO {TARGET}
  FROM (
                  SELECT COLUMN1, COLUMN2 FROM {SOURCE}
                ) AS TMP_TBL

- 기존 테이블 이용, 전체 컬럼 INSERT
INSERT INTO {TARGET} SELECT * FROM {SOURCE}

- 기존 테이블 이용, 일부 컬럼 INSERT
INSERT INTO {TARGET} SELECT COLUMN1, COLUMN2 FROM {SOURCE}

Blog at WordPress.com.