Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

Çë½ÌÒ»ÏÂÕâ¶Îsql server Óï¾ä ×°»»³Éoracle ¸ÃÔõôд

select @tables as tablesname into #425103tablename
while 1=1
begin
    select @i=charindex(',',tablesname) from #425103tablename;
    if @i=0 begin
      select @subTableName=tablesname from #425103tablename; 
      ......

¹ØÓÚASP SQL·À×¢È뺯Êý

ÍøÉÏÕÒÁËһЩÏֳɵÄASP·À×¢Èëϵͳ»òÎļþ£¬²âÊÔµÄʱºò¶¼·¢ÏÖÒ»¸öÎÊÌ⣬ϵͳÀï×ÜÊÇÓÐÄÇô¼¸¸öÒ³Ãæ£¬ÔÚInclude·À×¢ÈëÎļþºó·ÃÎʱ»Ìáʾ·¢ÏÖ×¢Èë´úÂ룬¶øÕâÐ©Ò³ÃæµÄurlµ÷ÓòÎÊýÖ»ÊDZȽϳ¤¶øÒѰÕÁË£¬Òª²»¾ÍÊÇServer.URLEncode¹ý£¬55£¬·À×¢ÈëÕ¦ÕâôÄѸ㣿ÇóÕý½â

»òÕß˵Äܲ»ÄÜÌṩ×î¹Ø¼üµÄ¼¸¸öÒª¹ýÂ˵Ĺؼü×Ö
......

¹ØÓÚASP SQL·À×¢È뺯Êý

ÍøÉÏÕÒÁËһЩÏֳɵÄASP·À×¢Èëϵͳ»òÎļþ£¬²âÊÔµÄʱºò¶¼·¢ÏÖÒ»¸öÎÊÌ⣬×ÜÊÇÓÐÄÇô¼¸¸öÒ³Ãæ£¬ÔÚInclude·À×¢ÈëÎļþºó±»Ìáʾ·¢ÏÖ×¢Èë´úÂ룬¶øÕâÐ©Ò³ÃæµÄurl²ÎÊýÖ»ÊDZȽϳ¤£¬55£¬·À×¢ÈëÕ¦ÕâôÄѸ㣿ÇóÕý½â
±ðÓÃͨÓõ쬏ù¾Ý×Ô¼ºµÄÐèÒª×Ô¼ºÐ´¡£
......

sqlÓï¾äÇó½â

µÚÒ»´Î·¢Ìû£¬ÊµÔڸ㲻¶¨Õâ¸öÓï¾ä¡£

ÃèÊö£º±í½á¹¹ÊÇ  xuanti(sno,tname1,tname2)ÊÇÒ»¸öÂÛÎÄÑ¡Ìâ±í£¬¾ÍÊÇѧУѧÉúͨ¹ýϵͳѡÔñÂÛÎÄÖ¸µ¼ÀÏʦ£¬Ã¿¸öѧÉú¿ÉÒÔÑ¡Á½¸öÀÏʦÐγÉÁ˱íµÄÄÚÈÝ£¬snoÊÇѧºÅ£¬tname1ÊÇѧÉú×÷Ϊһ־ԸѡÔñµÄÀÏʦ£¬tname2ÊÇѧÉú×÷Ϊ2־ԸѡÔñµÄÀÏʦ

ÎÊÌâ———ÎÒÏëͳ¼ÆÑ¡Ô ......

Ò»ÌõSQLÓï¾ä£¡

¸øÏÂÃæÕâÑùµÄÒ»¸ö±í¼Ç¼£º
------------------------------------
¹ºÎïÈË      ÉÌÆ·Ãû³Æ    ÊýÁ¿
A            ¼×          2
B            ÒÒ          4
C&nb ......

sqlÐÞ¸ÄÊ¡·ÝÖµ

¸÷λºÃ£¡

      ±¾ÈË×î½üÓöµ½Ò»¸öÎÊÌ⣬ÔõôÐÞ¸ÄÊý¾Ý¿â±íÖеÄ×Ö¶ÎÖµ£¬ÎÒÓÐÕâÑùÒ»¸ö±í
      Ê¡·Ý        ³ÇÊÐ
      ¹ã¶«      ¹ãÖÝ
      ¹ã¶«      ¶«Ý¸
      ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [378] [379] [380] [381] 382 [383] [384] [385] [386] [387]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ