Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

JDBCÁ¬½ÓSQLserverÎÊÌâ ÓôÃÆ~

ÓÖ³öÏÖ£ºcom.microsoft.sqlserver.jdbc.SQLServerException: ûÓÐΪ¼¯³ÉÉí·ÝÑéÖ¤ÅäÖÃÇý¶¯³ÌÐò¡£Õâ¸ö´íÁË ÉÏ´ÎÏ¡ÀïºýÍ¿µÄ¸øŪ³öÀ´ÁË £¬Õâ´ÎŪÁË°ëÌ춼ûÆ×£¬Õâµ½µ×ÊÇɶԭÒò£¡
×Ô¼ºÏȶ¥Ò»¸ö

ÊDz»ÊÇû´òsp3 ²¹¶¡°¡

ÒýÓÃ
ÊDz»ÊÇû´òsp3 ²¹¶¡°¡

.

ÊÇûÓÐSQLserverÇý¶¯³ÌÐòÂð

ÏÂÔØ£ºSQL Server 2000 SP3£¬Í¬Ñùµ½MicrosoftµÄÍøվȥÏÂÔØÉý¼¶°ühttp://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn£¬ÏÂÔØÆäÖеÄchs_sql2ksp3.exe£¬×¢ÒâÏÂÔØÏÂÀ´µÄÊÇchs_sql2ksp3.exeÎļþ,Ë«»÷ËüÑ¡Ôñ°²×°µ½Ò»¸öĿ¼ʱÊÇÔÚ½âѹ,È»ºóÄ㻹Ҫµ½ÄǸöĿ¼ÏÂË«»÷setup.batÅú´¦ÀíÎļþ²ÅÊÇ¿ªÊ¼°²×°(Ó¦¸Ã˵ÊÇÉý¼¶)!!!¾ßÌåÏÂÔصØÖ·ÊÇ£ºhttp://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2kasp3.exe
~~~~~~~~~~~~~~~~~~~~¹Ø¼ü½áÊø~~~~~~~~~~~~~~~~~~~~~~~~~×¢£ºÎÒÒ»Ö±ÊÇÕâ¸öÔ­Òò£¬×°´í²¹¶©ÁË£¬ÎÒÔø¾­×°¹ýSP3a£¬SP4£¬½á¹û¶¼²»ÐУ¡2£¬°²×°JDBC£¬°ÑÆ䰲װĿ¼ÏµÄlibϵÄÈý¸öÎļþÌí¼Óµ½classpathÖУ¬Õâ¸öÍøÉ϶¼ÓкܶࡣÎÒµÄÊÇ£ºC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;Ìí¼ÓÍê³Éºó£¬°²×°SP3²¹¶©£¬Ò²¾ÍÊǸղÅϵÄÄǸöÎļþ£¬

ûµ¼Çý¶¯°ü°É£¿ÔÚWEB-INFµÄlibÅäÖù¹½¨Â·¾¶µ¼Èësqljdbc.jar°üÊÔÊÔ

ûÓÐsqlserverµÄjdbcÇý¶¯°ü

1,Êý¾Ý¿âÇý¶¯Ã»µ¼Èë
2,²¹¶¡Ã»´ò


Òª²»¾ÍÊÇȱÉÙ°ü£¬Òª


Ïà¹ØÎÊ´ð£º

ÇóÒ»ÐÐÒµÍøÔ´Âë(C#+sqlserver)

ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍƼöÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾

ʲôÐÐÒµ°¡....

µ½51aspx.co ......

Çó½Ì ²é¿´SqlServerÖ´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæʱ²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......

Ôõô»ñÈ¡sqlserver×îºó²åÈëÐÐÄÚµÄ×ֶΣ¿

Ö÷¼üÊÇuniqueidentifierÀàÐÍ£¬Ã»ÓÐ×ÔÔö×ֶΡ£¡£

ÕâÑùÓ¦¸ÃÔõô»ñÈ¡£¿


L@_@K
SQL code:
SELECT ISNULL(SCOPE_IDENTITY(), -1) AS [SCOPE_IDENTITY]

°´Ê±¼äÅÅÐò
»ò
guid²»Òª×Ô¶¯Éú³É
......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ