[thelist] SQL Server & Stored Procedures

[Anthony Baratta]

At 09:20 PM 10/29/2001, you wrote:

>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?

Straight from the SQL 7 on-line books:

UPDATE authors SET au_lname = 'Jones' WHERE au_id = '999-888-7777'
IF @@ROWCOUNT = 0
         print 'Warning: No rows were updated'

Hope that helps.
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."