例子:
declare @a table
(
a varchar(100) not null,
b varchar(100) not NULL,
c INT IDENTITY(1,1)
)
BEGIN TRAN
BEGIN TRY
INSERT INTO @a( a )
VALUES ('aaaa')
END TRY
BEGIN CATCH
END CATCH
IF @@ERROR = 0
COMMIT TRAN
ELSE
ROLLBACK TRAN
INSERT INTO @a
( a, b )
VALUES ( 'qqq','3333')
SELECT * FROM @a
被插入表中标识字段的值也进行增加