oracleÖÐsqlЧÂʵÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí
ÕâÁ½ÌõsqlÒâ˼ÊÇ´ÓÌû×Ó±íÖÐÈ¡Ìû×Ó£¬À¸Ä¿Ãû³Æ´Óarticle_lm±íÖлñµÃ select a.tid,a.bt,a.ftr,a.ftsj,b.lmmc from article a left join article_lm b on a.lmid=b.lmid select a.tid,a.bt,a.ftr,a.ftsj,(select lmmc from article_lm where a.lmid=lmid) lmmc from article a ÈçÉÏÁ½ÌõsqlÓï¾ä£¬ÎÒÏëÖªµÀÄÄÌõЧÂʸßһЩ£¬ÎªÊ²Ã´£¿
ÊÔÑéÁË Ï ²î±ð²»ÊǺܴó ÔÚÊý¾ÝÁ¿ 1000 W ÊDzî±ð Ò²²»ÊǺܴó 0.125 £¬0.078 ¸öÈ˸оõÉÏ Á¬½Ó»á ЧÂʸߵã ÒýÓà ÕâÁ½ÌõsqlÒâ˼ÊÇ´ÓÌû×Ó±íÖÐÈ¡Ìû×Ó£¬À¸Ä¿Ãû³Æ´Óarticle_lm±íÖлñµÃ select a.tid,a.bt,a.ftr,a.ftsj,b.lmmc from article a left join article_lm b on a.lmid=b.lmid select a.tid,a.bt,a.ftr,a.ftsj,(select lmmc from article_lm whe¡¡ ²é¿´Ã¿ÌõÓï¾äµÄÖ´Ðмƻ®£¬¾ÍÖªµÀ˵ÄЧÂʸߡ£ ÎÒ¾õµÃÓ¦¸ÃÐÔÄܲ¶à.µ«ÊǾßÌåµÄÊý¾Ý»·¾³ÏÂÃæORACLE¾ö¶¨µÄÖ´Ðмƻ®¿ÉÄÜÓÐÇø±ð.ËùÒÔ×îºÃÊǸù¾ÝÖ´Ðмƻ®À´ºâÁ¿ÄĸöºÃÄĸö²»ºÃ. ¸öÈ˾õµÃµÚ2ÖֱȽϺà fromºóÃæ²»Òª+ºÜ¶à±í ¹âƾÁ½ÌõSQLÓï¾ä˵ЧÂÊÊDz»Ì«×¼È·µÄ ÐèÒª¿´Á½ÕűíÖеÄÊý¾ÝÁ¿ÒÔ¼°ÏàÓ¦Óï¾äµÄÖ´Ðмƻ®À´½øÐÐÅÐ¶Ï ¸öÈ˸оõµÚÒ»ÌõÖ´ÐеÄЧÂʸߣ¬²»ÖªµÀ¶Ô²»¶Ô¡£
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º DECLARE @STR NVARCHAR(MAX) SET @STR='SELECT * from SALE_PROD' ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿ Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡ ¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡ Ö±½ÓÖ´ÐоÍÐÐÁË exec ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,... CreateTble C=Answer N="»ØÌû±í" ( C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false, C=Ques ......