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

ÇóÒ»¸öSQLÓï¾ä - .NET¼¼Êõ / ASP.NET

ÓÐSQL SERVER Êý¾Ý¿âÁ½¸ö 
  ±íA subject teacher ±íB SUDENT CLASS SCORE 
  Êýѧ ÍõÀÏʦ ÕÅÈý Êýѧ 100
  ÓïÎÄ ÁõÀÏʦ ÀîËÄ ÓïÎÄ 80
ÎÒÏëµÃµ½ÕâÑùµÄ½á¹û£º
  sudent class teacher score
  ÕÅÈý Êýѧ ÍõÀÏʦ 100
  ÕÅÈý ÓïÎÄ ÁõÀÏʦ 0£¨»òÕßδ¿¼ÊÔ£©
  ÀîËÄ Êýѧ ÍõÀÏʦ 0£¨»òÕßδ¿¼ÊÔ£©
  ÀîËÄ ÓïÎÄ ÁõÀÏʦ 80

ÇëÎÊÕâ¸öSQLÓï¾äÔõô£¿
 
°ï¶¥
  »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡

ÕÅÈý ÓïÎÄ 0 
 ÀîËÄ Êýѧ 0
//B±íÖÐûÓÐÉÏÊý¾Ý£¿



¿´²»¶®±í½á¹¹¡£
select A¡£sudent £¬b¡£class£¬a.teacher,b.score
form a

left join b on a.class=b.class

select sudent class teacher score from A,B

×Ðϸ¿´ÁËһϣ¬LZ ²»ÐèÒªÓõ½ÐÐתÁÐ

ʹÓà left join ¾Í¿ÉÒÔÁË

¶Ô£¬¾ÍÊÇB±íÖÐûÓÐÊý¾Ý£¬¾ÍÒªÏÔʾ0
ÒýÓÃ
ÕÅÈý ÓïÎÄ 0
ÀîËÄ Êýѧ 0
//B±íÖÐûÓÐÉÏÊý¾Ý£¿


±íA subject teacher ±íB SUDENT CLASS SCORE  
  Êýѧ ÍõÀÏʦ ÕÅÈý Êýѧ 100
  ÓïÎÄ ÁõÀÏʦ ÀîËÄ ÓïÎÄ 80
C# code:
select b.sudent,a.teacher,b.class,b.scroe where a.subject=b.class group by sudent

{


Ïà¹ØÎÊ´ð£º

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

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

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

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

ÇóÖúasp.netͼƬÉÏ´« - .NET¼¼Êõ / ASP.NET

¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£

ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

ASP¡£netÖÐÔõôµ÷ÓÃCom+×齨 - .NET¼¼Êõ / ASP.NET

C# code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Runtime.InteropServices;
nam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ