BEGIN TRYBEGIN TRAN-- 业务操作INSERT INTO Products (ProductName, Price) VALUES ('新产品', 99.99)-- 数据验证IF EXISTS (SELECT 1 FROM Products WHERE ProductName = '新产品' AND Price < 100)BEGIN;THROW 50001, '产品价格不能为负数', 1 ENDCOMMIT TRAN END TRY BEGIN CATCHIF (@@TRANCOUNT > 0)beginROLLBACK TRAN;--这里的分号一定要加THROW;ENDEND CATCH