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;