SQL²éѯ - .NET¼¼Êõ / ASP.NET
Êý¾Ý¿âÓÐÁ½¸ö×ֶΣºÌû×ÓÊýºÍÖ÷ÌâÊý ÏëÒª²éѯ£º½ñÌìµÄÌû×ÓÊýºÍÖ÷ÌâÊýµÄ×ܺͣ¬ÈÕÆÚÊǽñÌ죬ÇëÎÊSQLÓï¾äÔõôд£¿
select ×ܺÍ=Ìû×ÓÊý+Ö÷ÌâÊý from table where ÈÕÆÚ=½ñÌìÒýÓà select ×ܺÍ=Ìû×ÓÊý+Ö÷ÌâÊý from table where ÈÕÆÚ=½ñÌì Õâ»Ø¸´Ì«Ç¿ÁË£¬¶¥ÒýÓà select sum(Ìû×ÓÊý£©+sum(Ö÷ÌâÊý) as ºÏ¼Æ from table where datediff(day,createdate,getdate())=0 Õý½âÒýÓà Êý¾Ý¿âÓÐÁ½¸ö×ֶΣºÌû×ÓÊýºÍÖ÷ÌâÊý ÏëÒª²éѯ£º½ñÌìµÄÌû×ÓÊýºÍÖ÷ÌâÊýµÄ×ܺͣ¬ÈÕÆÚÊǽñÌ죬ÇëÎÊSQLÓï¾äÔõôд£¿ Õý½â
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
±¾È˹¤×÷¾ÑéÒ»ÄêÒÔÉÏ ÊìϤasp.net ÊìϤjavascript ÊìϤCss ÊìϤajax ÊìϤsqlserver2005 ÓÐÒ»ÄêµÄÏîÄ¿¾Ñé ¾ßÌåÏîÄ¿ºÍÆäËûµÄ¾Í²»ÔÚÕâдÁË ÓÐÒâÕßÁªÏµ£º QQ:359233910 ÒýÓà ±¾È˹¤×÷¾ÑéÒ»ÄêÒÔÉÏ ÊìϤasp ......
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£ ²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£ ÎÒÏëÓÃjsд ÇóÖú Äã¿ÉÒÔ°Ñdrop ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......