ÓÐÁ½¸ö±í¡£·Ö±ð¶¼ÓÐ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µÄÓû§Ã ......