摘要： 一、查询效率分析语句/*set statistics io on;set statistics time on;*/二、 查出重复数据 select [GUID] from @Tab where [GUID] in (select [GUID] from @Tab group by [GUID] having count([GUID])>1) order by [GUID] 三、一个常用的想不来的语句且已被遗忘UPDATE a SET a.SaleZQ = b.OrganizationNameFROM @WaitCheckImei a,EmoAsp.dbo.TB_ASP_Org... 阅读全文