ÇóÒ»¸ö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 {
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£ ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£ ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£ ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£ 2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ ) ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
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 ......