sqlserver 简单的事物用法

SELECT * FROM Interface_UserPort


BEGIN TRY
    BEGIN TRAN Tran_2012_12_25
        INSERT INTO dbo.Interface_UserPort VALUES(2,3)
        --raiserror 50005N'抛出错误' 
    COMMIT TRAN Tran_2012_12_25
END TRY
BEGIN CATCH
    raiserror 50005N'出错了' 
    ROLLBACK TRAN Tran_2012_12_25
END CATCH