CREATE PROCEDURE procedureName (@var1 as varchar(50),@var2 as varchar(50))--建立未發臨時表ASbegin tran--doSthDUMP TRANSACTION GJJ WITH NO_LOG ---------1.清空日志BACKUP LOG GJJ WITH NO_LOG ------------2.截斷事務日志DBCC SHRINKDATABASE(GJJ) ----------------- 3.收縮數據庫IF @@ERROR>0 BEGINROLLBACKENDELSE BEGINCOMMITENDGO