ÓйØsqlserver 2008 Á¬½Óʧ°ÜµÄÎÊÌâ
¸÷λ´óÏÀÇë°ï°ï棬ÎÒµÄÊý¾Ý¿âÁ¬½Ó³ÌÐò³öÎÊÌâÁË£¬ÒÔÇ°Ò²¾³£ÓûáÓõ½Ëü£¬µ«ÊÇÕâÒ»´Î²»ÖªµÀΪʲôһֱ¸ã²»¶¨£¬ÏÂÃæÊÇÎÒÒªÌáÎʵÄÎÊÌ⣺,°´Àí˵ÕâÖÖÎÊÌâºÜ¼òµ¥£¬Ò»°ã¾ÍÊÇÒòΪJAR °üûÓÐÒýÈëÔì³ÉµÄ£¬¿ÉÊÇÎÒµÄJAR°ü¶¼ÒýÈëÁË£¬¶øÇÒÎÒ°ÑÁ¬½ÓµÄ´úÂëÔÚÆäËûµÄ¹¤³ÌÏÂ×öÁ˲âÊÔ£¬ÊÇ¿ÉÒÔÁ¬½Ó³É¹¦µÄ£¬µ«ÊÇ´ú·Åµ½ÎÒÔ´³ÌÐòÖÐÈ´×ÜÊDZ¨ÕâÖÖ´íÎó£¬ÓôÃÆ°¡£¡ÎÒµÄÔ´³ÌÐòÈçÏ£º£¬ÁíÍâµÄÔ´³ÌÐòÓõ½ÁËstruts¿ò¼Ü£¬ÎÒµÄÕâ¶Î´úÂëÊǷŵ½Ò»¸öactionÖÐ×ö²âÊÔÊý¾Ý¿âÁ¬½ÓÓõģ¬Çë´ó¼Ò¸øÎÒÖ¸µãÒ»¶þ¡£¡£¡£¡£¡£¡£¡£¡£¡£
ллÄ㣬ÎÒµÄÎÊÌâÒѾ½â¾öÁË£¬ÊÇÎÒ°Ñ"com.microsoft.sqlserver.jdbc.SQLServerDriver"д´íÁË¡£
Ïà¹ØÎÊ´ð£º
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......
Sqlserver±í½á¹¹
Create table test
(
int parentID primary key identity(1,1),
int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
1   ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡
±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ ......
3GµÄVS2008£¬ºÃÏñĬÈÏ°²×°µÄʱºò´øÁ˺ܶණÎ÷¡£±ÈÈçsqlserver2005£¬µ«ÊÇÎÒ²»ÖªµÀÕâ¸ö¸½´øµÄsqlserver2005ºÍsqlserver2005ÓÐʲô¹Øϵ£¿
Ò»¸öÊÇÔËÐл·¾³£¬Ò»¸öÊdzÌÐò£¿
Èç¹û×°ÁËvs2008£¬ÔÙ×°sqlserver2005ºÃÏñÓÖ ......