<update id="SAVE_QQS" parameterType="Map"> MERGE T_QQS AS A USING (SELECT #{MEM_NO} AS MEM_NO , #{GROUP_NO} AS GROUP_NO , #{PASS_MONTH} AS PASS_MONTH , #{PASS_DAY} AS PASS_DAY , #{PASS_YN} AS PASS_YN , #{UNPASS_PRIVATE_CD} AS UNPASS_PRIVATE_CD , #{BIRTH_YEAR} AS BIRTH_YEAR , #{SEX} AS SEX , #{SPOINT_CD} AS SPOINT_CD , #{SPOINT_SIDO} AS SPOINT_SIDO , #{SPOINT_DONG} AS SPOINT_DONG , #{SPOINT_NM} AS SPOINT_NM , #{DEL_YN} AS DEL_YN , #{INS_PERSON_ID} AS INS_PERSON_ID , Convert(Varchar(10),GetDate(),112) AS INS_DATE , replace(Convert(Varchar(8),GetDate(),24),':','') AS INS_TIME) AS B ON A.MEM_NO = B.MEM_NO AND A.GROUP_NO = B.GROUP_NO WHEN NOT MATCHED THEN INSERT( MEM_NO , GROUP_NO , PASS_MONTH , PASS_DAY , PASS_YN , UNPASS_PRIVATE_CD , BIRTH_YEAR , SEX , SPOINT_CD , SPOINT_SIDO , SPOINT_DONG , SPOINT_NM , DEL_YN , INS_PERSON_ID , INS_DATE , INS_TIME) VALUES( B.MEM_NO , B.GROUP_NO , B.PASS_MONTH , B.PASS_DAY , B.PASS_YN , B.UNPASS_PRIVATE_CD , B.BIRTH_YEAR , B.SEX , B.SPOINT_CD , B.SPOINT_SIDO , B.SPOINT_DONG , B.SPOINT_NM , B.DEL_YN , B.INS_PERSON_ID , B.INS_DATE , B.INS_TIME) WHEN MATCHED THEN UPDATE SET A.PASS_MONTH = B.PASS_MONTH , A.PASS_DAY = B.PASS_DAY , A.PASS_YN = B.PASS_YN , A.UNPASS_PRIVATE_CD = B.UNPASS_PRIVATE_CD , A.BIRTH_YEAR = B.BIRTH_YEAR , A.SEX = B.SEX , A.SPOINT_CD = B.SPOINT_CD , A.SPOINT_SIDO = B.SPOINT_SIDO , A.SPOINT_DONG = B.SPOINT_DONG , A.SPOINT_NM = B.SPOINT_NM , A.DEL_YN = B.DEL_YN , A.INS_PERSON_ID = B.INS_PERSON_ID , A.INS_DATE = B.INS_DATE , A.INS_TIME = B.INS_TIME ; </update>
이런 MSSQL INSERT쿼리문이 있는데.. 이걸 셀렉트 해주려면 어떻게 해줘야하나요?.....
또... 강제로 INSERT를 시켜주고 싶은데... 값을 강제로 넣어야 할 부분이 감이안오네요...
힌트라도 주시면 감사하겠습니다.