sqlµ¼ÈëµÄÎÊÌâ
ÎÒÔÀ´µÄsql2000Êý¾Ý¿âÉÏÓкܶàµÄÓû§,ÏÖÔÚÏë°ÑÕâЩÓû§¶¼µ¼³öµ½Ò»¸öеÄÊý¾Ý¿âÀӦ¸ÃÔõô×ö£¿Çë½Ì¸÷λ?!
sql2000ºÃÏñÖ»Äܵ¼Êý¾Ý¿â£¬²»ÖªµÀµÇÈëÓû§Ôõôµ¼Èë¡£Çë¸÷λ¸ø¸ö´ð°¸£¬Ð»Ð»£¡
»¹ÊÇÖØÐ½¨Á¢°É
Óû§²»Äܵ¼,ÔÚϵͳÊý¾Ý¿âµÄ,н¨°É
¹Ø¼üÊÇÄÇô¶àµÄÓû§£¬¶øÇÒ¶¼ÓÐÃÜÂ룬ÎÒ²»ÄܰÉÃÜÂë¶¼¸ÄÁ˰¡£¬Ã»°ì·¨Öؽ¨Å¶£¡
¸÷λ´ó¸ç£¬ÓÐʲôºÃ·½·¨°¡£¿
http://blog.csdn.net/fredrickhu/archive/2009/10/14/4669511.aspx
¿´¿´Õâ¸ö
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE
ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
Ò»Õűítable×Ö¶ÎF1ºÍF2
F1 F2
1 a
2 ......