BEGIN TRAN BEGIN TRY DELETE FROM dbo.表INSERT INTO dbo.表( Id, 字段....)SELECTId,字段... FROM dbo.表 COMMIT TRAN END TRY BEGIN CATCH ROLLBACK END CATCH