AccessÁ¬½ÓÓï¾ä²éѯ½á¹ûÓësql2005²»Ò»ÖÂ

SQL code:

select count(1) from HouseList a left join MemberList b on
(a.OperationName=b.UName and a.Eid=1 and a.houselc='2')


ÒÔÉÏÕâÌõÓï¾äÔÚsql2005ÖвéѯµÃµ½760Ìõ¼Ç¼,·ÅÔÚaccessÖвéѯֻÓÐ14Ìõ¼Ç¼.,.

¶øÇÒaccessºÃËƲ»Ö§³Ö¶àÌõ¼þ²éѯ,Èç¹ûºóÃæÓжà¸öÌõ¼þ,±ØÐëÒªÓÃ()¹ÎÆðÀ´.,·ñÔò³ö´í.,

ÇëÎÊaccessÖÐÓÐʲô°ì·¨,ÄÜÏñsqlÖÐÄÇÑù,inner joinºó,Äܵõ½Õâ760Ìõ¼Ç¼.,.

---

sf°ï¶¥£¬access²»ÊìϤ

---

access²»ÊìϤ
幫頂~~

---

SQL code:



1.ÔÚSQL SERVERÀï²éѯaccessÊý¾Ý:
-- ======================================================
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=')...±íÃû
-------------------------------------------------------------------------------------------------
2.½«accessµ¼ÈëSQL server
-- ======================================================
ÔÚSQL SERVER ÀïÔËÐÐ:
SELECT *
INTO newtable
from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...±íÃû
-------------------------------------------------------------------------------------------------
3.½«SQL SERVER±íÀïµÄÊý¾Ý²åÈëµ½Access±íÖÐ
-- ================================================