BEGIN TRAN
BEGIN TRY
DELETE FROM dbo.表
INSERT INTO dbo.表
(
Id,
字段....
)
SELECT
Id,字段...
FROM dbo.表
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK
END CATCH
转载于:https://www.cnblogs.com/hualiuliu/p/11471025.html
BEGIN TRAN
BEGIN TRY
DELETE FROM dbo.表
INSERT INTO dbo.表
(
Id,
字段....
)
SELECT
Id,字段...
FROM dbo.表
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK
END CATCH
转载于:https://www.cnblogs.com/hualiuliu/p/11471025.html