Transactional stored procedure Operations

--###########################################################################--function: Transaction stored procedure inserting data--writing idea: just to be lazy! --########################################################################## #IF (object_id (' Sp_CreatSevenDoc ', N ' P ') is not NULL)    DROP PROC sp_creatsevendocgocreate PROC sp_addcustomsperson    @uName NVARCHAR (+),--user name    as BEGIN        DECLARE @res int= 0;        Begin try            begin tran//Transaction Execution Code            COMMIT TRAN        END TRY        begin CATCH            SET @res = 0;            ROLLBACK TRAN        END CATCH        RETURN @res;    END   GO

　　

Transactional stored procedure Operations