sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bednum) bednum ÿ¸öËÞÉáÒ»¹²µÄ´²Î»Êý
ÏÖÔÚÒÔÉÏÁùÕÅ±í¶¼ÒѾºÃÁË£¬ÏëÒÔѧԺ°à¼¶Îªµ¥Î»ÊµÏÖÈëסµÄ¹ý³Ì£¬Éú³É±ístuindorm.
˳ÐòÉú³É ÏȲ»Óÿ¼ÂǺܶàÒòËØ°É ÄÐÅ®·Ö¿ª¼´¿É ¾ÍÊÇAѧԺA1°à¼¶Ñ§ÉúÈëסµ½KÇøK1´±101-205µÄÈýºÅ´²Î»(¼ÙÉèÒ»¹²ËÄÕÅ´²Î» Õâ¸öÊDZäµÄ) ÔòAѧԺA2°à¼¶Ñ§Éú½Ó×ÅÈëסÏÂÈ¥ÕâÑù
Ò»¸öѧԺ¶à¸ö°à¼¶¶à¸öѧÉú
Ò»¸öסËÞÇø¶à¸öËÞÉáÂ¥¶à¸öËÞÉá Õâ¸ö½¨±íµÄʱºò¿ÉÄܲ»Ôõô׼ȷ
ËÞÉáÂ¥£ºKÇøK1Â¥£¬K2Â¥¡£¡£¡£
ËÞÉ᣺101-110 201-210..601-610
лл´ó¼ÒÁË- -
stuindorm(sid,rid,bid,did)
ѧÉúÈëס±í(ѧÉú±àºÅ£¬×¡ËÞÇø£¬Â¥ºÅ£¬ËÞÉáºÅ)
СF ÄãÖÕÓÚ³öÀ´ÁË¡£¡£ÄÚÅ£¡£¡£
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò
ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ.
sqltext="select top A * from log where id not in(select top ( ......