SQL SERVER2000ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
1¡£Êý¾Ý¿âÁ¬½ÓµÄʱºò£¬Èç¹ûÎÒÓÃÁ¬½Ó³Ø£¬°Ñ×î´óÁ¬½ÓÊýÉèÖÃΪ5£¬ÄÇôϵͳÔÚÎåÌìÒÔºóÊý¾Ý¿â¾Í»á±¨´í£¬Èç¹ûÎÒÉèÖÃΪ10£¬ÔòϵͳÔÚÊ®Ììºó¾Í³öÏÖ´íÎ󣬸оõºÜÆæ¹Ö¡£ËÄܰïÎÒ½âÊÍÏÂÂð£¿Ð»Ð»..
2¡£³ÌÐò¿ªÊ¼ÔËÐÐÕý³££¬¼¸Ììºó¾Í»áÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬´Ó5ÔÂ20ÈÕ²¼ÉϵijÌÐòÔËÐÐÕý³£µ½5ÔÂ27ºÅÁ¬½ÓÁíÒ»¸ö·þÎñÆ÷ÉϵÄÊý¾Ý¿âʱ¾ÍÁ¬½Óʧ°ÜÁË£¬ÓÐËÓöµ½¹ýÕâ¸öÎÊÌâÂð£¿
3¡£Á¬½Ó±¾µØÊý¾Ý¿âʱ£¬Ò²ÊÇ¿ªÊ¼¼¸ÌìÔËÐÐÕý³££¬½ñÌì·¢ÏÖÊý¾Ý¿â±¨³öһϴíÎó
SQL code:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]½«
½Ø¶Ï×Ö·û´®»ò¶þ½øÖÆÊý¾Ý¡£
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(
Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType
(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.c
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
Ôõô°Ñ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Õ¾Àï ±¾ÉíÓÐ ......