Error Condition For Updates

Hi,

I have a series of Updates that I perform on 7 tables. I would like to execute these updates on a nighly basis via a job. I have the update statements lined up in a stored proc.

So I have -

Create Proc Update
AS
SET NOCOUNT ON

DECLARE @RETURNVALUE int
DECLARE @ERRORMESSAGETXT varchar(510)
DECLARE @ERRORNUM int

set @RETURNVALUE = 0

BEGIN ---Start here

Update table1
Update table2
.
.
.
Update table7

SELECT @ERRORNUM = @@ERROR
IF @ERRORNUM = 0
SELECT @RETURNVALUE = 0
ELSE
BEGIN
SELECT @ERRORMESSAGETXT = description FROM [master].[dbo].[sysmessages]
WHERE error = @@ERROR
RAISERROR (@ERRORMESSAGETXT, 16, 1)
SELECT @RETURNVALUE = 1
END
RETURN @RETURNVALUE
END --- END HERE

---

Is the error checking at the appropriate place? Should I have error conditions after every update? If yes then what condition do I check for?

Thanks