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
Ïà¹ØÎÊ´ð£º
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã
Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......