mssql temp table을 사용한 select insert SELECT * INTO #tempBigTable FROM AGENT_INFO WHERE AGENT_NO = '9999999999'; SELECT * FROM #tempBigTable; ALTER TABLE #tempBigTable Drop column [REG_NO]; -- DO something DROP TABLE #tempBigTable; 프로그래밍/MSSQL 2016.10.26