34,588
社区成员
发帖
与我相关
我的任务
分享
BEGIN TRY
BEGIN TRAN
INSERT INTO B(xx)
SELECT xx FROM A WHERE 1=1--条件
DELETE A WHERE 1=1--同上条件
COMMIT TRAN
END TRY
BEGIN CATCH
RAISERROR(N'出错了',16,1)
ROLLBACK TRAN
END CATCH
BEGIN TRY
BEGIN TRAN
INSERT INTO B(xx)
SELECT xx FROM A WHERE 1=1--条件
DELETE A WHERE 1=1--同上条件
COMMIT TRAN
END TRY
BEGIN CATCH
RAISERROR(N'出错了',16,1)
END CATCH