![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MsSql
文章平均质量分 65
lianghaim
这个作者很懒,什么都没留下…
展开
-
sql两个查询结果left join
select times,R.name,date,indate,outdate,money,predatefrom (select count(*) as times,name,sum(datediff(day,indate,outdate))as date,min(indate)as indate,max(outdate) as outdate,sum(datediff(原创 2014-09-18 20:31:55 · 1896 阅读 · 0 评论 -
Win7 WMI配置致SQL SERVER无法安装的解决办法
http://lxmaxiaogang.blog.163.com/blog/static/7828192200992174354784/转载 2014-09-13 18:00:25 · 1503 阅读 · 0 评论 -
按优先级插入临时表的存储过程
ALTER procedure [dbo].[test]ascreate table #temp(keyid varchar(8),artid varchar(8))Insert Into #temp(keyid,artid)select keyid,artidfrom TC_KNEADBILLwhere STATUS in (2)and artid in (select mi原创 2014-10-25 21:45:28 · 342 阅读 · 0 评论