Database/MSSQL1 MERGE 구문 MERGE dbo.e_uservideoprogress AS targetUSING (SELECT @employeeid AS employeeid, @videoid AS videoid) AS sourceON (target.employeeid = source.employeeid AND target.videoid = source.videoid) WHEN MATCHED THEN UPDATE SET watchedtime = @watchedtime, iscompleted = @iscompleted, lastwatchedat = @lastwatchedat WHEN NOT MATCHED THEN INSERT (employeei.. 2025. 6. 26. 이전 1 다음