[thelist] SQL Server & Stored Procedures

[spinhead]

(fuzzy off-the-top-of-my-head answer) You should be able to check @@ROWCOUNT

If @@ROWCOUNT <> 0 Then
    do the deed

spinhead


----- Original Message ----- 
From: "Beau Hartshorne" <beau at cubeinc.ca>
To: "thelist" <thelist at lists.evolt.org>
Sent: Monday, October 29, 2001 5:22 PM
Subject: [thelist] SQL Server & Stored Procedures


> 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
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>