34,588
社区成员
发帖
与我相关
我的任务
分享
BEGIN
DECLARE @nextId int;
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
BEGIN TRANSACTION;
SELECT @nextId=IDENT_CURRENT( 'Test10' ) +1;
DBCC CHECKIDENT( 'Test10',RESEED, @nextId);
SELECT @nextId;
INSERT INTO Test11 (cnvcUseName) VALUES (@nextId);
COMMIT TRANSACTION;
END
BEGIN
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
BEGIN TRANSACTION;
INSERT INTO Test10 (cnvcUseName) VALUES (GETDATE());
COMMIT TRANSACTION;
END