数据库中事务用法举例

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		爱因光
-- Create date: 2012年3月21日14:37:10
-- Description:	事务基本用法
-- =============================================
CREATE PROCEDURE sp_TranTest
AS
BEGIN
	SET NOCOUNT ON;
	BEGIN TRAN
	SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
	IF (@@ERROR <> 0)
	BEGIN
	    RAISERROR(N'发生错误', 16, 1)
	    ROLLBACK
	    RETURN -1
	END
	
	COMMIT
END
GO