Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) Microsoft Analysis Services 客户端工具 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 ) Microsoft 数据访问组件 (MDAC) 6.1.7600.16384 (win7_rtm.090710-1945) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 8.0.7600.16384 Microsoft .NET Framework 2.0.50727.4927 操作系统 6.1.7600
SQL code:
EXEC sp_addlinkedserver @server = 'SEATTLE Mktg', @provider = 'Microsoft.ACE.OLEDB.12.0', @srvproduct = 'OLE DB Provider for ACE', @datasrc = 'E:\Program Files (x86)\Microsoft Office\Templates\2052\Access\Northwind.accdb' GO
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 上面一个简单的SQL,执行时间2.6� ......
第一句: select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je from ht left join gfdm on ht.gfdm=gfdm.gfdm join jh on ht.htbh=jh.hth and ht.htbh not like'del%' and ht. ......
