ɾ³ýSQLServer²éѯ·ÖÎöÆ÷ÖеÄÁ¬½Ó¼Ç¼
SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀï¶¼»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers
¶ÔÓÚ2005ϵÄstudioÈçºÎɾ³ý
ɾ³ýC:\Documents and Settings\{User}\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellϵÄmru.dat
Ïà¹ØÎĵµ£º
½ñÌì±àдÁËÒ»¸ö·ÖÒ³£¬ÔÚµ÷ÊÔÖгöÏÖÁËÈçϵĴíÎó:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid call Statement method: {0}
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown ......
ÔÚʹÓÃÊý¾Ý¿âµÄ¹ý³ÌÖУ¬¾³£»áÓöµ½Êý¾Ý¿âÇ¨ÒÆ»òÕßÊý¾ÝÇ¨ÒÆµÄÎÊÌ⣬»òÕßÓÐͻȻµÄÊý¾Ý¿âË𻵣¬ÕâʱÐèÒª´ÓÊý¾Ý¿âµÄ±¸·ÝÖÐÖ±½Ó»Ö¸´¡£µ«ÊÇ£¬´Ëʱ»á³öÏÖÎÊÌ⣬ÕâÀï˵Ã÷¼¸ÖÖ³£¼ûÎÊÌâµÄ½â¾ö·½·¨¡£
¹ÂÁ¢Óû§µÄÎÊÌâ
±ÈÈ磬ÒÔǰµÄÊý¾Ý¿âµÄºÜ¶à ......
ÔÚ SQLServer2005 ÖÐ¶Ô XML µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË query(),value(),exist(),modify(),nodes() µÈº¯Êý¡£
¹ØÓÚ xml £¬ÄÑÒÔÀí½âµÄ²»ÊÇ SQLServer ÌṩµÄº¯Êý£¬¶øÊÇ¶Ô xml ±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»ÊdzõÌ ......
Ò» ²âÊÔ»·¾³
Ò» ²âÊÔ»·¾³
²Ù×÷ϵͳ Red Hat As 2.1
Êý¾Ý¿â SQLServer2000 installed in windows xp professional£¬ÎÒ¼Ù¶¨Êý¾Ý¿âÓÐÓû§autotest ÃÜÂëÊÇautotest£¬Êý¾Ý¿âÎļþÊÇatsdb
×¢Ò⣺ &n ......
SQLServer CodeSmith C#
bigint Int64   ......