How to get detect wether error has occured in stored procedure?

61.

Checking @@Error value

Checking ##Error value

Checking @@ErrorCode value

Checking @@ErrorNumber value

Checking @@ErrorStatus value

@Error value returns 0 if no error has occured otherwise it returns 1