sql ¼± ÔÚÏßµÈ - MS-SQL Server / »ù´¡Àà
ͬһ¸ö·þÎñÆ÷£¬ Êý¾Ý¿âȨÏÞ²»Í¬£¬±ÈÈç A ±í ÐèÒªÕ˺Ša,ÃÜÂë aa b±í ÐèÒªÕ˺Šb,ÃÜÂëbb
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷£¬ ²»ÐèÒª²Ù×÷×Ö·û´®
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË
Õâ¸ö?»¹ÕæÃ»ÓÐÕâô¸ã¹ý.
»¹Êǽ¨ÒéÄãÓøöͬһµÄÕʺŰÉ.×îºÃÊÇsa.
Èç¹û¶ÔA¡¢B±í½øÐвÙ×÷µÄ»°£¡¿ÉÒÔÏȰѶÔÏó²Ù×÷ȨÏÞɾ³ý£¬²Ù×÷ÍêºóÔÙ¶Ô¶ÔÏóÊÚȨ£¡
²»ÖªµÀÕâÑù°²È«²»£¿µÈ´ý¸ßÈË....
ÐèÒª¸ã¸öÐéÄâ»ú ÔÙ×°¸öʵÀýÀ´½øÐÐÁ´½Ó·þÎñÆ÷²Ù×÷
¸ã¸öÐéÄâ»ú!½éÈëµÚÈý·½...ºÇºÇ...¶¥...
ÎÒµÄÒâ˼ÊÇ ÏÖÔÚÓÖÁ½¸öÊý¾Ý¿âÁ´½Ó×Ö·û´®£¬ÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÀïÓÃÁíÒ»¸ö×Ö·û´®£¬×Ö·û´®µ±²ÎÊý´«½ø
Õâ¸öÎÊÌâÊÇÓеã¹Ö£¬ºÇºÇ£¬»¹Êǽ¨Ò»¸ö¶¼ÓÐȨÏÞµÄÕ˺Űɣ¡
Õâ¸ö¿ÉÒÔÓÃopenrowset
ÁíÒ»¸ö×Ö·û´®À´Ô´ÊÇÄÄÀï
Ïà¹ØÎÊ´ð£º
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Ä ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......