작성일 : 12-10-29 10:34
|
[MsSQL] 프로시저에서 임시 테이블 삭제
|
 |
|
글쓴이 :
조형래
 조회 : 3,142
|
if object_id ('tempdb..#S_TB_COMPANY_PRODUCT_TMP') is not null
BEGIN
DROP table #S_TB_COMPANY_PRODUCT_TMP
END
SELECT
DISTINCT COM_SEQ,COM_PRODUCT_YR,COM_PRODUCT_KISU,EDU_SDATE,PRODUCT_ID INTO #S_TB_COMPANY_PRODUCT_TMP
FROM S_TB_COMPANY_PRODUCT
SELECT * FROM #S_TB_COMPANY_PRODUCT_TMP
|
|
1758
