[thelist] SQL Server & Stored Procedures

[Beau Hartshorne]

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