按以下格式寫沒有問題:IF NOT EXISTS (SELECT * FROM tabWorkingRecord WHERE record_id=@Originalrecord_id ) RAISERROR ('Record has been changed by other users,you must requery again',16, 1) ELSE BEGIN UPDATE tabWorkingRecord SET record_id =@record_id ,record_date =@record_date WHERE record_id =@Originalrecord_id END
RAISERROR ('Record has been changed by other users,you must requery again',16, 1)
ELSE
BEGIN
UPDATE tabWorkingRecord
SET record_id =@record_id ,record_date =@record_date
WHERE record_id =@Originalrecord_id
END