事务脚本

USE [test]
GO

BEGIN tran v_1_0_2_1 --指定版本号

declare @tran_error int
set @tran_error=0
begin try

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[test]’) AND type in (N’U’))
DROP TABLE [dbo].[test]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[test](
[Id] [tinyint] NOT NULL,
[Name] [INT] NULL,
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT [dbo].[test] ([Id], [Name]) VALUES (1, ‘fdg’)

INSERT [dbo].[test] ([Id], [Name]) VALUES (2, 222)

end try
begin CATCH

select
‘执行失败’ AS ‘执行结果’,
ERROR_NUMBER() ‘错误代码’,
ERROR_SEVERITY() ‘严重级别’,
ERROR_STATE() ‘错误状态码’,
ERROR_PROCEDURE() ‘错误的存储过程或触发器的名称’,
ERROR_LINE() ‘错误行号’,
ERROR_MESSAGE() ‘具体信息’

set @tran_error=@tran_error+1
end catch
if(@tran_error>0)

begin
rollback tran

end
else
begin
commit TRAN
SELECT ‘执行成功’ AS ‘执行结果’
END