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

Çë½Ì¹ØÓÚ2¸öSQLµÄ±È½Ï

select * from a,b where a.city="±±¾©" and b.city="±±¾©"
select * from  a,b where b.city=a.city  and a.city="±±¾©" ÄǸö¸ü¿ì£¿


Ï£ÍûÄÜ˵³öÔ­Òò¡£Ð»Ð»
±í½á¹¹Ò»ÑùµÄ»°£¬ÕâÁ©Óï¾äÓ¦¸ÃÊǵȼ۵ġ£


¿´¿´Ö´Ðмƻ®¡£

¼ÇµÃORACLE¶ÔÕâÑùµÄ´¦Àí»úÖÆÊÇÒ»ÑùµÄ,¿ÉÒÔ¿´×÷¶¼ÊÇÈ·¶¨µÄÖµ,¶ø²»½øÐйØÁª

ÒýÓÃ
¼ÇµÃORACLE¶ÔÕâÑùµÄ´¦Àí»úÖÆÊÇÒ»ÑùµÄ,¿ÉÒÔ¿´×÷¶¼ÊÇÈ·¶¨µÄÖµ,¶ø²»½øÐйØÁª


ÄÇÕâô˵£¬ÊǵÚÒ»¾äµÄЧÂÊÒª¸ßÂ

Ò»ÑùµÄ


ÒýÓÃ
ÒýÓà 3 Â¥ huntian8 µÄ»Ø¸´:ÒýÓà 2 Â¥ java3344520 µÄ»Ø¸´:¼ÇµÃORACLE¶ÔÕâÑùµÄ´¦Àí»úÖÆÊÇÒ»ÑùµÄ,¿ÉÒÔ¿´×÷¶¼ÊÇÈ·¶¨µÄÖµ,¶ø²»½øÐйØÁª ÄÇÕâô˵£¬ÊǵÚÒ»¾äµÄЧÂÊÒª¸ßÂ
Ôε¹°¡,ÄãÈ¥¿´¿´ORACLEµÄ´¦Àí»úÖÆ,ÎÒÍü¼ÇÔÚÄÄÀï¿´µ½,ORACLEÓкü¸ÖÖËÑË÷»úÖÆ,ÓнéÉÜ


ÄÇÄãµÄÒâ˼ÊÇÄĸöЧÂʸߣ¿»¹ÊÇÒ»Ñù¸ß£¿


Ò»Ñù........

µÈ´ýÄǸöOracle´óÅ£½â¾ö£¡£¡


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

¹ØÓÚSQL Server Mobile Edition - .NET¼¼Êõ / ASP.NET

¹ØÓÚSQL Server Mobile Edition
ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf
ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......

ÇóÒ»¸ö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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ