MS SQL - Conditional UPDATE return result
<p>I have a stored procedure which is doing the following.</p>

<p>The populated target table data is checked against several similar source tables for a match (based on name and address data). If a match is found in the first table then it updates the target with a flag identifying which source table the match was from. However if it doesn't find a match I need it to look in the next source table and the next until either a match is found or not as the case may be.</p>

<p>Is there an easy way for the UPDATE statement to provide some kind of return value I can query to say whether it updated the target table? I would like to use this return value so that I can skip checking subsequent source tables unnecessarily.</p>

<p>Otherwise will I have to perform the conditional UPDATE then do a separate query to determine if the UPDATE actually updated the flag?</p>