select a,b from #1 bb where exists(select 1 from (select distinct #1.a,#1.b,#2.a c,#2.b d from #1,#2) aa where aa.a=bb.a and aa.b=bb.b and aa.c=bb.c and aa.d=bb.d) group by a,b having count(*)>1
select a,b from #1 bb where exists(select 1 from (select distinct #1.a,#1.b,#2.a c,#2.b d from #1,#2) aa where aa.a=bb.a and aa.b=bb.b and aa.c=bb.c and aa.d=bb.d) group by a,b having count(*)>1
资源 地址
Microsoft 产品支持服务 Web 站点 http://support.microsoft.com/directory
Microsoft Usenet news://msnews.microsoft.com/
Microsoft Windows® 硬件兼容性列表 http://www.microsoft.com/hcl
MSDN® http://msdn.microsoft.com
Meta Data Services(即以前的 Microsoft 知识库) http://msdn.microsoft.com
SQL Server 专业协会 http://www.sqlpass.org/
Microsoft SQL Server 开发人员中心 http://msdn.microsoft.com
SQL Server 杂志 http://www.sqlmag.com/
Microsoft SQL Server 技术支持 http://support.microsoft.com/support/sql
TechNet 站点 http://www.Microsoft.com/technet
Microsoft 辅助工具 Web 站点 http://www.microsoft.com/enable
Microsoft SQL Server Web 站点 http://www.microsoft.com/sql
Microsoft SQL Server Web 站点上的 English Query 页 http://www.microsoft.com/sql
Microsoft SQL Server Web 站点上的 Analysis Services 页 http://www.microsoft.com/sql
XML 开发人员中心 http://www.msdn.microsoft.com/xml/default.asp