SQL Server 2008ʹÓà - MS-SQL Server / »ù´¡Àà
×î½ü×°Á˸öSQL Server 2008£»²»¹ýÎÒÓõÄÖ»Êǿͻ§¶Ë£¬Ò»¾ä¼òµ¥µÄselect * from table ×ÜÊÇÌáʾÎÞ·¨Æô¶¯T-SQLµ÷ÊÔ£»Î´½Óµ½·þÎñÆ÷£¬µÇ¼ʧ°Ü£»
µ«ÎÒÃ÷Ã÷¶¼¿´µ½ÉÏÃæµÄÊý¾Ý¿âºÍ±íÁË£»
ÔõôûÈËÖ§Õа¡
ûÓÐÓùý sql 08,°ï¶¥+ѧϰ¡£¡£¡£¡£¡£¡£ÅθßÊÖ½â´ð¡£¡£
¹ÖÊ£¬ÖØÆôSQL·þÎñÊÔÏ¡£
ÄãÓõÄʲôÕË»§µÇ¼µÄ£¿Èç¹ûÊÇwindowsÕË»§µÇ¼µÄ£¬ÊÔÊÔ¸ÄÓÃsql serverÕË»§µÇ¼£¬²¢ÇÒ±£Ö¤µÇ¼µÄÕË»§ÒªÓÐsql serverÖÐsysadminµÄȨÏÞ
¸Õ²ÅÊÔÁËÏ£¬°´ÄÇÀïÃæµÄÖ´Ðа´Å¥Ê±¾ÍÐÐÁË£¬°´µ÷ÊÔ¾ÍÊÇÉÏÃæËµµÄÎÊÌ⣻ÕâÊÇÔõô¸ãµÄ°¡?
¼ÌÐø¹Ø×¢¡£¡£°ï¶¥£¡
¾ÍûÈË»áÂð£¬Ã»ÈËÃ÷°×Âð£¿
¹þ¹þ¹þлл À´¿´¿´ ѧϰµÄ
¹Ø×¢Öа¡
ȷʵûÓÐÓöµ½¹ý¡£ °ï¶¥¡·¡£¡£
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......