sqlserver 大数据量的insert、delete操作优化

发布时间：2020-12-12 14:40:13 所属栏目：MsSql教程来源：网络整理

导读：? 经常使用的语句！? ? ?? ? --大批量导出orders表:insert ? ? DBCC?DROPCLEANBUFFERS??? DBCC?FREEPROCCACHE?? go? SET ?NOCOUNT? ON ?? BEGIN ? TRANSACTION ??? INSERT ? INTO ?test.dbo.orders? with (tablock)? SELECT ?*? FROM ?? bak.dbo.Orders? WHE

 
 
经常使用的语句！?
  
  ?
  
  ??
  
  ?
  
  --大批量导出orders表:insert?
  
  ?
  
  DBCC?DROPCLEANBUFFERS???
  
  DBCC?FREEPROCCACHE??
  
  go?
  
  SET?NOCOUNT?ON??
  
  BEGIN?TRANSACTION???
  
  INSERT?INTO?test.dbo.orders?with(tablock)?SELECT?*?FROM??
  
  bak.dbo.Orders?
  
  WHERE?ordertime?BETWEEN?'2010-05-01'?AND?'2010-05-10'?
  
  COMMIT?
  
  go?
  
  ?
  
  ?
  
  --大批量导出orders表:delete?
  
  ?
  
  DBCC?DROPCLEANBUFFERS???
  
  DBCC?FREEPROCCACHE??
  
  go?
  
  SET?NOCOUNT?ON??
  
  BEGIN?TRANSACTION???
  
  while?1=1???
  
  begin??
  
  ?delete?top(1000)?from?test.dbo.orders?with(tablock)??
  
  WHERE?ordertime?BETWEEN?'2010-05-01'?AND?'2010-05-10'?
  
  if?@@rowcount<1000??
  
  ?break???
  
  end??
  
  COMMIT?
  
  go?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!