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

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»Ì«×¼È·µÄ

ÐèÒª¿´Á½ÕűíÖеÄÊý¾ÝÁ¿ÒÔ¼°ÏàÓ¦Óï¾äµÄÖ´Ðмƻ®À´½øÐÐÅжÏ

¸öÈ˸оõµÚÒ»ÌõÖ´ÐеÄЧÂʸߣ¬²»ÖªµÀ¶Ô²»¶Ô¡£


Ïà¹ØÎÊ´ð£º

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ