--SECURITY 
DELETE FROM SECURITY WHERE CO_CD = '1000'
go

INSERT INTO SECURITY  (CO_CD, EMP_CD, MENU_CD, MODULE_CD, SEC_FG, INS_YN, EDIT_YN, DEL_YN, PRT_YN, REG_DT, INSERT_ID, INSERT_DT, INSERT_IP, MODIFY_ID, MODIFY_DT, MODIFY_IP, MY_MENU)
SELECT '1000', EMP_CD, MENU_CD, MODULE_CD, SEC_FG, INS_YN, EDIT_YN, DEL_YN, PRT_YN, REG_DT, INSERT_ID, INSERT_DT, INSERT_IP, MODIFY_ID, MODIFY_DT, MODIFY_IP, MY_MENU
FROM SECURITY WHERE CO_CD = '1100'
go