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Óï¾äÔõôд£¿ Õý½â
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû var pwd=document.all.txtOpwd; var div1=document.getElementById("divPwd"); if (pwd.value=="") { ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
´úÂëÈçÏ Çë¸ßÊÖ Ö¸µãÏ лл ajax_http.js ------------- function getXMLHTTP() { var xmlhttp; if (window.ActiveXObject) { //IE try { ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂ𣿠Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵ 3Q´ó¼Ò htmlÒ³Ãæ. Õâ¸ö,¼ÈÈ»Ö÷Ò ......