Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Èç¹ûдµÝ¹ésqlÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

ÓÐÁ½¸öͬÑùµÄ±í½á¹¹ 
±í½á¹¹ÈçÏ£º
  id£¨ÐòºÅ£© parentid £¨¸¸½áµãÐòºÅ£© name(½áµãÃû³Æ)
 ±í1 ¼Ç¼ 1 0 aaa
  2 0 bbb
  3 1 ccc

  ¡£¡£¡£¡£¡£¡£
±í2 ¼Ç¼  
  1 0 bbb
  2 0 xxx

  ¡£¡£¡£¡£
±í1Óë±í2¶¼ÊÇÊ÷×´½á¹¹¼Ç¼¡£ÏÖÐèÒª½«±í1¼Ç¼µ¼Èëµ½±í2ÖÐ £¬±í2ÖÐÒѾ­Óв¿·Ö¼Ç¼£¬ÓÐЩ¼Ç¼Óë±í1ÖмǼÏàͬ¡£
ÏÖÐèÒª½«±í1ÖеļǼµ¼Èëµ½±í2ÖУ¬ÐèÒªÅжϱí2ÖÐûÓбí1¼Ç¼µÄÐèҪȫ²¿µ¼È룬²¢ÇÒÊ÷×´½á¹¹ºÍ±í1ÖеĽṹһÖ¡£

Óô洢¹ý³ÌÒ²¿ÉÒÔ¡£Ð»Ð»¡£


 
  
 
MRAK »ØÈ¥ÔÙ¿´

¶¥ÏÂ



SQL code:


insert into ±í2
select * from ±í1 a where not exists
(select 1 from ±í2 b where a.id=b.id and a.parentid=b.parentid and a.name=b.name)



ÒýÓÃ
SQL codeinsertinto ±í2select*from ±í1 awherenotexists
(select1from ±í2 bwhere a.id=b.idand a.parentid=b.parentidand a.name=b.name)

¿ÉÒÔ³¢ÊÔ

Ŷ ЧÂʰ¡Ð§ÂÊ

Ô­À´ÕâÑùÕæµÄ¿ÉÒÔ¡£¡£ÏëÁË¡£Ã»


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sql 2000 ·þÎñÆô¶¯²»ÁË

Ö±½ÓÆô¶¯ µãÁ˵ÈÒ»»á¶ù¾Íû·´Ó¦ÁË È¥·þÎñÄÇÀïÆô¶¯»á³öÏÖÈçÏÂÌáʾ  
³öÏÖ¡°±¾µØ¼ÆËã»úÉϵÄMSSQLSERVER·þÎñÆô¶¯ºóÓÖÍ£Ö¹ÁË¡£Ò»Ð©·þÎñ×Ô¶¯Í£Ö¹£¬Èç¹ûËüÃÇûÓÐʲô¿É×öµÄ 
È»ºó»¹ÓÐʲôʲô²»´æÔÚ  ......

ÇóÒ»¸ösqlÓï¾ä

A±í          B±í
WZID WZJG    WZID  CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸ ......

Êý¾Ý´°¿Ú¶¯Ì¬ÐÞ¸ÄSql - PowerBuilder / DataWindow

ΪÁËÂú×ãÊý¾Ý²éѯµÄËÙ¶ÈÎÊÌ⣬ÎÒ½«Ò»ÕÅÊý¾ÝÁ¿´óµÄѧÉú±í°´Äê¶È·Ö³É¶à¸ö±í
students_2008, students_2009È»ºóÎÒÓÖ×öÁËÒ»¸öÄ£°å±ístudents_template,Ä£°å±íÖеÄ×ֶκÍstudents_2008, students_2009Ò»Ñù£¬Ö»²»¹ýÊÇÒ»¸ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ