°Ù·ÖÇóSqlÓï¾äÄÑÌâ¡£¡£
¼ÙÉèÓÐÒ»±í£¬±í½á¹¹Îª
StartDate,EndDate
¿ªÊ¼ÈÕÆÚºÍ½áÊøÈÕÆÚ
¶øÓû§ÊäÈëÁí2¸öÈÕÆÚStartDate2,EndDate2
StartDate2Ϊ2009-4-1
endDate2Ϊ2009-5-4
Èç¹û²éѯ±íÖÐStartDateºÍEndDateºÍÓû§ÊäÈëµÄʱ¼ä¼ä¸ôÓгåÍ»µÄ½á¹û
ÎÒ×öµÄÊÇÒ»¸ö¶©·¿¹ÜÀíϵͳ£¬Óû§ÊäÈëij¸ö·¿¼äµÄÈëסʱ¼äºÍÀ뿪ʱ¼äºó¡£¡£ÎÒÊÇÏë²éѯ¸Ã¶Îʱ¼äÊÇ·ñ´æÔÚÒѱ»Ô¤¶©µÄ¼Ç¼¡£¡£
ûͷÐ÷¡£¡£Ð»Ð»´ó¼Ò
Õâ¸ö³åÍ»Ôõô¸ö½âÊÍ
àÅ,½âÊÍÇå³þЩ
¼ÙÉèÓÐÒ»±í£¬±í½á¹¹Îª
StartDate,EndDate
¿ªÊ¼ÈÕÆÚºÍ½áÊøÈÕÆÚ
¶øÓû§ÊäÈëÁí2¸öÈÕÆÚStartDate2,EndDate2
StartDate2Ϊ2009-4-1
endDate2Ϊ2009-5-4
Èç¹û²éѯ±íÖÐStartDateºÍEndDateºÍÓû§ÊäÈëµÄʱ¼ä¼ä¸ôÓгåÍ»µÄ½á¹û
ÎÒ×öµÄÊÇÒ»¸ö¶©·¿¹ÜÀíϵͳ£¬Óû§ÊäÈëij¸ö·¿¼äµÄÈëסʱ¼äºÍÀ뿪ʱ¼äºó¡£¡£ÎÒÊÇÏë²éѯ¸Ã¶Îʱ¼äÊÇ·ñ´æÔÚÒѱ»Ô¤¶©µÄ¼Ç¼¡£¡£
ûͷÐ÷¡£¡£Ð»Ð»´ó¼Ò
±ÈÈç˵¿âÄÚÓÐÒ»ÌõÒѶ©·¿¼Ç¼ StartDate Ϊ2010/4/20 EndDateΪ2010/5/2
ÓÐÒ»¿ÍÈËÌá½»±íµ¥¶©2010/4/1 µ½ 2010/4/23ºÅµÄ·¿
ÎÒÏë×öµÄ¾ÍÊǸù¾Ý¿ÍÈËÌá½»µÄʱ¼ä¶Î£¬²éѯÊÇ·ñÊý¾Ý¿âµÃÖªÊÇ·ñÓпշ¿
µ¥¶ÀµÄÒ»Ìì±ÈÈç˵2010/4/1ÈÕ¡£Õâ¸öÎÒÖªµÀÓÃDatediff¾Í¿ÉÒԲ鵽£¬¹Ø¼üÊÇÒ»¸öʱ¼ä¶Î£¬ÈçºÎ×öµ½²éѯÊÇ·ñÓпշ¿
=¡£= Èç¹ûÔÚ³ÌÐòÉÏ×ö
ÎÒ¿ÉÒÔ½«Óû§ÊäÈëµÄ2010/4/1ºÅµ½2010/4/23ºÅ×ö¸öÑ»·
½«Ñ»·ÖеÄÿһÌìºÍ¿âÖеÄStartdateÒÔ¼°Enddate×öDatediff¶Ô±È
µ«ÕâÑù×ö¡£¡£Ì«ºÄ×ÊÔ´ÁË
{{----
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......