9807146wang的专栏

dump transaction data0505 with no_log go dbcc shrinkdatabase(data0505)

  set   @sql=Nselect @oogoodscount=SUM(TStoreDecStoreD.fResCount) from  TStoreDecStoreD   INNER JOIN TStoreDecStoreM ON (TStoreDecStoreD.fStoreDecStoreMID = TStoreDecStoreM.fStoreDecStoreMID)   WHERE