-- 事务
BEGIN TRY
BEGIN TRAN
--更新数据
UPDATE Table1 SET ...
UPDATE Table2 SET ...
IF @@ROWCOUNT=0
BEGIN
INSERT INTO Table2()
VALUES()
END
COMMIT TRAN
END TRY
BEGIN CATCH
--回滚
ROLLBACK TRAN
SET @strErrorDescribe=N'抱歉!程序错误。'
SELECT ERROR_MESSAGE() AS ErrorMessage
RETURN 105
END CATCH
BEGIN TRY
BEGIN TRAN
--更新数据
UPDATE Table1 SET ...
UPDATE Table2 SET ...
IF @@ROWCOUNT=0
BEGIN
INSERT INTO Table2()
VALUES()
END
COMMIT TRAN
END TRY
BEGIN CATCH
--回滚
ROLLBACK TRAN
SET @strErrorDescribe=N'抱歉!程序错误。'
SELECT ERROR_MESSAGE() AS ErrorMessage
RETURN 105
END CATCH