22,206
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T1
(
ID INT IDENTITY(1,1),
CREATEDATE DATETIME
)
INSERT INTO T1 VALUES(GETDATE())
SELECT @@IDENTITY
BEGIN TRAN
DECLARE @I INT
SET @I=0
WHILE @I<1000
BEGIN
INSERT INTO T1 VALUES(GETDATE());
SET @I=@I+1
END
ROLLBACK
INSERT INTO T1 VALUES(GETDATE())
SELECT @@IDENTITY