04 2018 档案

Sql查询过滤重复的数据
摘要：select CustCode,* from solist a where not exists(select 1 from SOList(nolock) left join so(nolock) on solist.soid=so.SOID where a.ConfirmDate>solist.C 阅读全文

posted @ 2018-04-30 22:08 wwwlzp 阅读(227) 评论(0) 推荐(0)

判断一个表里面有没有相同的数据
摘要：select * from (select code,count(code) num from mmf group by code) a where a.num>=2 阅读全文

posted @ 2018-04-30 21:39 wwwlzp 阅读(144) 评论(0) 推荐(0)

MSSQL如何将查询结果拼接成字符串
摘要：select SizeID,Matid,SizeCaption from mmfsize(nolock) where matid='000309' order by SizeID select (select SizeCaption+',' from mmfsize(nolock) b where 阅读全文

posted @ 2018-04-27 22:28 wwwlzp 阅读(981) 评论(0) 推荐(0)

SQL删除指定条件的重复数据，只保留一条
摘要：--删除重复外发工序delete from wwwp where id in (select max(wwwp.id) id from wwwp(nolock)inner join (select mpsid,mpsmatid,wpid ,count(*) NO from wwwp(nolock) 阅读全文

posted @ 2018-04-27 22:03 wwwlzp 阅读(230) 评论(0) 推荐(0)

清除日志
摘要：USE[master] GO ALTER DATABASE RossERP_R7 SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE RossERP_R7 SET RECOVERY SIMPLE --简单模式 GO USE RossERP_R7 GO 阅读全文

posted @ 2018-04-27 21:46 wwwlzp 阅读(127) 评论(0) 推荐(0)

导航