sitelink1 | http://database.sarang.net/?inc=read&...amp;page=2 |
---|---|
sitelink2 |
BEGIN TRAN
UPDATE Users_job
SET duty_cd=a.duty_cd, duty_name=a.duty_name, dpt_id=a.dpt_id
FROM (SELECT user_id, duty_cd, duty_name, dpt_id
FROM Users) A
WHERE Users_job.user_id = A.user_id
IF @@ERROR = 0
COMMIT
ELSE
ROLLBACK