USE master

Create Database TestDb
on Primary
(
 name='TestDb_data',
 filename='G:\TempData\Db\TestDb_data.mdf',
 size=5MB,
 filegrowth%
)
Log on
(
 name='TestDb_log',
 filename='G:\TempData\Db\TestDb_log.ldf',
 size=1MB,
 filegrowth%
)

USE TestDb

---创建表Table1
IF OBJECT_ID('Table1','U') IS NOT NULL
DROP TABLE Table1
GO
CREATE TABLE Table1
(ID INT NOT NULL PRIMARY KEY,
Age  ));  -- 满足条件才会插入；
GO

--测试事务
BEGIN TRANSACTION
INSERT INTO Table1(ID,Age)
,)
INSERT INTO Table1(ID,Age)
,)  --【注意】，小于上面设置的范围
INSERT INTO Table1(ID,Age)
,)
INSERT INTO Table1(ID,Age)
,)
COMMIT TRANSACTION
GO

delete Table1 --删除数据，方便演示数据；

@@ROWCOUNT (Transact-SQL)

BEGIN TRAN;
,) ;     BEGIN ROLLBACK TRAN;GOTO EndTran;END;
,) ;      BEGIN ROLLBACK TRAN;GOTO EndTran;END;
,) ;     BEGIN ROLLBACK TRAN;GOTO EndTran;END;
,) ;     BEGIN ROLLBACK TRAN;GOTO EndTran;END;

EndTran:
BEGIN

     AS Success;END
ELSE
     AS Success;END
END