I'm trying to figure out what sql syntax to use in order to select the row(s) affected value.
I'm using query analyzer with the following sql:
delete referrals where referralid = 6
When I run this it will say either "(1 row(s) affected)" or "(0 row(s) affected)"
Is there a way I can select that value? Sort of like select scope_identity() when doing an insert statement. Thanks for any help.