sqlServer事务

CREATE PROCEDURE DelRowsByID
    @id int
AS
BEGIN
    begin transaction
    begin try
    --sql
    end try
    begin catch
        if @@trancount>0
            rollback transaction
    end catch
        if @@trancount>0
            commit transaction
    
END