Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæʱ²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlServerÖÐÊÇ·ñÒ²ÓÐÀàËƹ¦ÄÜÄØ£¬µÚÒ»´ÎÌáÎÊ£¬Íû´ó¼ÒÖ¸µã °¡
¹À¼ÆÒª½èÖúLOG EXPLORER
ѧϰ
ûÈËÖ¸µãÂð£¿Èç¹ûûÈËÖ¸µãÎÒÖ»ÄÜÔËÓÃ×Ô¼ºµÄ±¿·½·¨ÁË¡£×Ô¼º½¨Ò»¸ö´æ´¢¹ý³ÌµÄÈÕÖ¾±í£¬Ã¿´ÎËÔËÐÐÕâ¸ö´æ´¢¹ý³Ì£¬ÏȲåÈëµ½Õâ¸ö±íÀïÒ»Ìõ¼Ç¼¡£°¥£¬ÎÒÅÂÕâÑù»áÓ°ÏìÐÔÄÜ
Ïà¹ØÎÊ´ð£º
1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......
±¾ÈËÍü¼ÇÁËsaµÄÃÜÂë¡£
ÔÚ¡°°²È«ÐÔ¡±¡ú¡°µÇ¼¡±¡ú¡°saÊôÐÔ¡±¸ü¸ÄÃÜÂëÖ®ºó,ÔÚÖØеǽ¡£
µÇ¼ʧ°Ü¡£
ÓÃwindowsÓû§µÇ½
´úÂë¸ü¸Ä£ºsp_password Null,'123456','sa' »¹ÊÇ
µÇ¼ʧ°Ü¡£
ÔÚ¡°·þÎñ¡±¡ú¡°ÊôÐÔ¡±¡ú¡°µ ......
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error ......
ÔÚÒ»¸ö±íͬʱ¸üжàÌõÊý¾Ý ²»ÒªËµÓÃin
¸÷λ´óϺ°ï°ïæ
ʲôÒâ˼?ÐèҪʲôÌõ¼þ?²»ÐèÒªÌõ¼þÄǾÍÖ±½Ó¸üÐÂßÂ
update xxx set yyy=zzz
Ò»´ÎUpdateÓï¾ä£¬Ö»ÄܸüÐÂÒ»¸ö£¬ÒªÃ´¶à´ÎUpdate,Ҫôдһ¸ö´æ´¢¹ý³Ì£¬´æ´¢¹ý³Ì ......
ERPÈí¼þµÄÊý¾Ý¿âÊÇSQLSERVER2000µÄ£¬¹«Ë¾ÈÃÎÒ×ö¸öÍøÕ¾£¬ÆäÖÐÓÐЩÊý¾ÝÊǵ÷ÓÃERPÀïµÄ£¬ÎÒÏëÓÃPHP×öÍøÕ¾£¬µ«ÊDz»ÖªµÀPHP·ÃÎÊSQLSERVER¿âºÃʵÏÖ²»£¬ÔÙ¾ÍËٶȷ½ÃæÓ°Ïì²»»áÌ«´ó°É£¿¸úASP·ÃÎÊSQLSERVERÏà±ÈËٶȱ仯´ó²»£¿£¨ ......