[thelist] SQL Server & Stored Procedures
Beau Hartshorne
beau at members.evolt.org
Mon Oct 29 23:19:45 CST 2001
Hi,
I have a stored procedure that looks something like this:
DELETE FROM NEWS_COMMENTS_DEV WHERE comment_id = @comment_id UPDATE
NEWS_ARTICLES_DEV SET a_comments = a_comments - 1 WHERE news_id =
@news_id
I would like to execute the UPDATE statement only if the DELETE command
managed to delete something. So what's the best way to do this?
Thanks,
Beau
More information about the thelist
mailing list