![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
td13560142839
这个作者很懒,什么都没留下…
展开
-
sql语句导入导出大全
/******* 导出到excel exec master..xp_cmdshell 'bcp settledb.dbo.shanghu out c:\temp1.xls -c -q -s"gnetdata/gnetdata" -u"sa" -p""' /*********** 导入excel select * from opendatasource( 'micros翻译 2012-05-26 16:50:16 · 895 阅读 · 0 评论 -
sql优化几种情况分析
--清空查询分析器的缓存 dbcc dropcleanbuffers SELECT fas_id,fas_theme from tempA where fas_theme SELECT fas_id,fas_theme from tempA where fas_theme>‘’ --前提是处理过isnull(fas_theme,'') as fas_theme Into 临时表原创 2013-04-12 15:51:58 · 682 阅读 · 0 评论