test for UPDATE/INSERT success 1

[mp89]

Is it possible to test whether or not an UPDATE or INSERT actually updated/inserted a row in your stored procedure?


Cheers,

Mike

 

[vongrunt]

@@ERROR for success/failure status and @@ROWCOUNT to get number of row(s) affected... is that enough?

 

[mp89]

Thanks Vongrunt,

Excellent, just the type of test I was looking for :

--on insert

if @@rowcount = 0
--no rows were inserted


--on update

if @@rowcount = 0
--no rows were updated


Cheers,

Mike