SQL SERVER 2000 °²×°Ìáʾ"Ò»°ãÐÔÍøÂç´íÎó"
½ñÌì°²×°SQL SERVER 2000 ¸öÈ˰棬°²×°×îºóµ¯³ö´íÎó¶Ô»°¿ò£º
“°²×°³ÌÐòÅäÖ÷þÎñÆ÷ʧ°Ü¡£²Î¿¼·þÎñÆ÷´íÎóÈÕÖ¾ºÍC:\windows\sqlstp.log”£¬´Ó¶øÎÞ·¨°²×°¡£
µ½¾ßÌåµÄĿ¼²é¿´ÏÔʾ"Ò»°ãÐÔÍøÂç´íÎó"£¬ÔÚÍøÉÏËÑË÷ÎÊÌâÔÒò¼°½â¾ö·½°¸ÈçÏ£º
´ËÎÊÌâÊôÓÚsql serverµÄbug, GetComputerName ÓÃÓÚ»ñÈ¡±¾µØ¼ÆËã»úÃû¡£¿Í»§¶ËÍøÂç¿â×é¼þ (DBMSLPCn.dll) ½«¸ÃÃû³Æת»»ÎªÈ«²¿´óд¡£·þÎñÆ÷ÍøÂç¿â×é¼þ (SSMSLPCn.dll) ±£Áô·µ»ØʱµÄÃû³Æ¡£µ± Windows ¼ÆËã»úÃû³Æ°üº¬´óд×ÖĸºÍСд×Öĸ»òÕ߶¼ÊÇСд×Öĸʱ°²×°»áʧ°Ü£¬Ìáʾһ°ãÐÔÍøÂç´íÎó!
¾ßÌå½â¾ö£º½â¾ö·½·¨ÊǰѼÆËã»úÃûÈ«¸Ä³É´óд¾ÍÐÐÁË¡£
¾¹ýÑéÖ¤£¬Õâ¸ö·½·¨¾ø¶ÔÕýÈ·¡£¶ø¸ù¾ÝÎÒÕâ´Î½â¾öÎÊÌâµÄ¾Ñ飬ÔÙ¼ÓÒ»¸öϸ½Ú¡£
ÔÚ“ÎҵĵçÄÔ”ÉÏ·½£¬ÓÒ¼ü“ÊôÐÔ”->“¼ÆËã»úÃû”->“¼ÆËã»úÃèÊö”ÀïÃæ¿ÉÒÔÖ±½ÓÐ޸ġ£
ÎÒµÚÒ»´Î¾ÍÊÇÕâÑù¸ÄµÄ£¬µ«·¢ÏÖÔÚ“sqlstp.log”ÀïÃæÏÔʾµÄ¼ÆËã»úÃûÈÔÈ»²»ÊÇ´óд£¬Ôõô°ìÄØ£¬ÎÒ¾ÍÔÚ×¢²á±íÀïÃ潫ËùÓÐÓû§Ãû»òÓû§ÓòÃûÏà¹ØµÄСдµÄ¶¼ÕÒ³öÀ´£¬¸Ä³É´óд£¬ÖØÆôºó£¬°²×°¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
ÄãÖªµÀXMLÎļþ°É£¿£¨²»ÖªµÀµÄGOOGLEÈ¥£¡£©ÄÇÄãÌý˵¹ýÔÚXMLÀïÊéдSQLÓï¾äÂ𣿻»¾ä»°Ëµ£¬°ÑÄãµÄÏîÄ¿ÀïËùÓÐSQLÓï¾ä´æ´¢ÔÚXMLÎļþÀÄãÌý˵¹ýÂð£¿Äã×ö¹ýÂð£¿
ÎÒÍ·´ÎÌý˵ÊÇС°¬¸æËßÎҵģ¬ÎҸҿ϶¨ËûÊǸöÕâ·½ÃæµÄ¸ßÊÖ£¬ºÇºÇ£¨ÔÞÒ»¸ö£¬µ½´ËΪֹ£¡£©
ÄǸøÄãչʾһÏ£¬ÔÚXMLÀïÊéдSQLÓï¾ä°É
<commands>
<comman ......
select * from sq_donglong.achi_news where ID in (select ID from (select top 6 ID from sq_donglong.achi_news where SortID=82)a union all select ID from (select top 6 ID from sq_donglong.achi_news where SortID=84)b)
......
½ñÌìÓöµ½¸öÓÐÒâ˼µÄÎÊÌ⣬ÊÇÒ»¸ö·Ö×éÅÅÐòµÄÎÊÌ⣬²»¹ýÒªÇó·Ö×éºÍ·Ö×é¼äÒ²ÒªÅÅÐò£¬Èç¹ûÕâ¸ö×éÄÚÓÐÒ»ÌõÊý¾ÝÊÇ×î½ü¸üеģ¬ÄÇôÕâÕû¸ö×鶼Ӧ¸ÃÅÅÔÚÇ°Ãæ¡£
ÏÂÃæÒÔOracleµÄHRʾÀýSchemaÖеÄemployees±íΪÀý£º
Óï¾ä°´²¿ÃÅ·Ö×飬·Ö×éÖ®¼äµÄÅÅÐòÊÇÕâÑùµÄ£ºÈç¹ûÕû¸ö·Ö×éÖÐÓÐÒ»¸öÔ±¹¤µÄhire_dateÊÇ×îеģ¬ÄÇôÕâ¸ö·Ö×é¾ÍÓ¦¸ÃÅÅÔÚÆä ......
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Ä㶼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâƪÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......
ÎÒÃÇÔÚ¿ª·¢¹ý³ÌÖУ¬¾³£Óöµ½ÕâÑùÎÊÌ⣬¾ÍÊÇÒªÇó¶¨ÆÚ½øÐÐÊý¾Ý¿âµÄ¼ì²é£¬Èç¹û·¢ÏÖÌض¨Êý¾Ý£¬ÄÇô¾ÍÒª½øÐÐijÏî²Ù×÷£¬Õâ¸öÐèÇóÄØ£¬¿ÉÒÔÀûÓÃWindowsµÄ¼Æ»®ÈÎÎñ£¬¶¨ÆÚÖ´ÐÐijһ¸öÓ¦ÓóÌÐò£¬È¥¼ìË÷Êý¾Ý£»Ò²¿ÉÒÔÈóÌÐò×Ô¼º¿ØÖÆ¡£ÆäʵSQL Server×Ô¼ºÒ²¿ÉÒÔ´´½¨¼Æ»®ÈÎÎñ£¬¶¨ÆÚ½øÐÐÖ´ÐС£Èç¹ûÊý¾Ý¿â·þÎñÆ÷ÔÊÐí£¬¿ÉÒÔ¿¼ÂDzÉÓÃÕâÖÖ·½Ê½¡£
......