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