怎样验证存储过程没出错??

Question

create proc aaaaaaaas..........

能不能在存储过程里做什么标记.表示这个存储过程顺利完成?这样子.
比如什么error ..就好像  try catch finally 那样.

Answer 1

http://topic.csdn.net/u/20080415/16/5f28e77a-3e46-48f6-9ff4-b332006a8257.html                DECLARE @Error
                SET @Error == @@error
                BEGIN TRANSACTION
                
                -- do something.
                           
                IF @Error <> 0
                BEGIN
                    ROLLBACK
                    RAISERROR (@Error,16,1)
                    RETURN
                END        
                ELSE
                BEGIN
                    COMMIT TRANSACTION
                    RETURN
                END

Answer 2

使用raiserror将出错信息抛出，如果米有抛出异常信息，则存储过程成功执行