ÓÐÁ½¸ö±í¡£·Ö±ð¶¼ÓÐIDÖ÷¼ü¡£A±íµÄIDºÍB±íµÄIDÊǶÔÓ¦µÄ£¬¾ÍÊÇA±í¼¸¸öID£¬B±í¾Í¼¸¸öID¡£A±íµÄIDÊÇʲô,B±íµÄID¾ÍÊÇʲô¡£ ¿ÉÊÇÏÖÔÚA±íµÄID±ÈB±íµÄ¶àÁË¡£ ÎÒÏÖÔÚÏëÒª°ÑB±íÖÐÉٵIJ¿·Ö¸ø²¹ÆëÁË¡£Õâ¸ö²åÈëÓ¦¸ÃÔõôд°¡£¿SQL code: insert into B(ID) select id from a where id not in (select id from b)
ÎÒ×°µÄÊÇwindows7 £¬Êý¾Ý¿âÏëÓÃsql server 2008Á¬asp£¬²»¹ýÎÒ²»ÖªµÀsql server 2008µÄÓû§ÃûºÍÃÜÂëÁË£¬ÏëÓÃwinÑéÖ¤£¬ÊÔÁ˼¸±éû³É¹¦£¬Çë´ó¼Ò°ïæ¡£ ˳±ãÎÊһϣ¬ÎÒÔõôÄܲé³öÀ´×Ô¼ºsql 2008µÄÓû§Ã ......
´íÎóÐÅÏ¢£º Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][Shared Memory]ÎÞЧµÄÁ¬½Ó¡£ /bbsxp/test.asp, µÚ 24 ÐÐ