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

Delphi SQL ÅúÁ¿²åÈë - Delphi / Êý¾Ý¿âÏà¹Ø

ÓÐÈý¸ö±í£º
a(ID1,Name1);
b(ID2,Name2);
c(ID1,ID2);

aÖÐID1¶ÔÓ¦µÄÊý¾ÝÓУº
a1,a2,...,am
bÖÐID2¶ÔÓ¦µÄÊý¾ÝÓУº
b1,b2,...bn

ÔÚDelphiÖÐÈçºÎд¸ßЧµãµÄÓï¾ä£¬Ê¹µÃÄܹ»½«ÏÂÃæµÄÊý¾Ý²åÈëµ½c±íÖУº
a1,b1
a1,b2
...
a1,bn
...
a2,b1
a2,b2
...
a2,bn
...
...
am,b1
am,b2
...
am,bn

ÎÒÓõÄÊÇADOQueryÁ¬½ÓÊý¾Ý¿âµÄ¡£
ÏÈÓòéѯÉú³Éa¡¢b¹ØÁªµÄ±í£¨·ûºÏÄã¸ñʽҪÇóµÄ£©£¬È»ºóÓòåÈëÓï¾ä£¬½«²éѯ½á¹û²åÈëµ½c±íÖС£

ÏÈÓòéѯÉú³Éa¡¢b¹ØÁªµÄ±í£¨·ûºÏÄã¸ñʽҪÇóµÄ£©£¬È»ºóÓòåÈëÓï¾ä£¬½«²éѯ½á¹û²åÈëµ½c±íÖС£
{{


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×ֶΠ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ