[MS-SQL] Update ~ Select

Update ~ Select

[ZUPPER's Code]

-- 첫번째 방법 update TB_Tempset NickName = B.Nick from dbo.TB_Nick as Bwhere TB_Temp.ID = B.Mem_ID -- 두번째 방법 update TB_Tempset NickName =(SELECT Nick from dbo.TB_Nick where TB_Temp.ID = Mem_ID)<br /> UPDATE TAPRO_MENU_AUTH SET TAPRO_MENU_AUTH.READ_YN = TMP.READ_YN ,TAPRO_MENU_AUTH.CREATE_YN = TMP.CREATE_YN ,TAPRO_MENU_AUTH.UPDATE_YN = TMP.UPDATE_YN ,TAPRO_MENU_AUTH.DELETE_YN = TMP.DELETE_YN ,TAPRO_MENU_AUTH.ADMIN_YN = TMP.ADMIN_YN ,TAPRO_MENU_AUTH.UDT_DATE = GETDATE() ,TAPRO_MENU_AUTH.UDT_USER_ID = @USER_ID FROM #TMP_TABLE AS TMP WHERE TAPRO_MENU_AUTH.AUTH_CODE = @AUTH_CODE AND TAPRO_MENU_AUTH.MENU_CODE = TMP.MENU_CODE