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

ÓйØsqlserver 2008 Á¬½Óʧ°ÜµÄÎÊÌâ

¸÷λ´óÏÀÇë°ï°ï棬ÎÒµÄÊý¾Ý¿âÁ¬½Ó³ÌÐò³öÎÊÌâÁË£¬ÒÔÇ°Ò²¾­³£ÓûáÓõ½Ëü£¬µ«ÊÇÕâÒ»´Î²»ÖªµÀΪʲôһֱ¸ã²»¶¨£¬ÏÂÃæÊÇÎÒÒªÌáÎʵÄÎÊÌ⣺,°´Àí˵ÕâÖÖÎÊÌâºÜ¼òµ¥£¬Ò»°ã¾ÍÊÇÒòΪJAR °üûÓÐÒýÈëÔì³ÉµÄ£¬¿ÉÊÇÎÒµÄJAR°ü¶¼ÒýÈëÁË£¬¶øÇÒÎÒ°ÑÁ¬½ÓµÄ´úÂëÔÚÆäËûµÄ¹¤³ÌÏÂ×öÁ˲âÊÔ£¬ÊÇ¿ÉÒÔÁ¬½Ó³É¹¦µÄ£¬µ«ÊÇ´ú·Åµ½ÎÒÔ´³ÌÐòÖÐÈ´×ÜÊDZ¨ÕâÖÖ´íÎó£¬ÓôÃÆ°¡£¡ÎÒµÄÔ´³ÌÐòÈçÏ£º£¬ÁíÍâµÄÔ´³ÌÐòÓõ½ÁËstruts¿ò¼Ü£¬ÎÒµÄÕâ¶Î´úÂëÊǷŵ½Ò»¸öactionÖÐ×ö²âÊÔÊý¾Ý¿âÁ¬½ÓÓõģ¬Çë´ó¼Ò¸øÎÒÖ¸µãÒ»¶þ¡£¡£¡£¡£¡£¡£¡£¡£¡£

ллÄ㣬ÎÒµÄÎÊÌâÒѾ­½â¾öÁË£¬ÊÇÎÒ°Ñ"com.microsoft.sqlserver.jdbc.SQLServerDriver"д´íÁË¡£


Ïà¹ØÎÊ´ð£º

sqlserverÖбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈµÄº¬Òå

sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É

identity?ɶÒâ˼£¿

IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......

.NET²åÈëSQLSERVERÑÓʱÎÊÌ⣿ - .NET¼¼Êõ / C#

ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôԭÒò
Äã×öÁË»º´æÂð£¿

û×ö»º´æ

Ôõô»áÄØ£¡ ......

SQLSERVERÊý¾Ýµ¼³öµ½Access

Sqlserver±í½á¹¹
Create table test
(
  int parentID primary key identity(1,1),
  int childID
)go
ps:childIDÖ¸¶¨parentIDÖµ
ÓÐÈçÏÂÊý¾Ý
parentID childID
  1   ......

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡

±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ ......

vs2008´øµÄsqlserverºÍsqlserverÓÐʲô¹Øϵ£¿

3GµÄVS2008£¬ºÃÏñĬÈÏ°²×°µÄʱºò´øÁ˺ܶණÎ÷¡£±ÈÈçsqlserver2005£¬µ«ÊÇÎÒ²»ÖªµÀÕâ¸ö¸½´øµÄsqlserver2005ºÍsqlserver2005ÓÐʲô¹Øϵ£¿
Ò»¸öÊÇÔËÐл·¾³£¬Ò»¸öÊdzÌÐò£¿
Èç¹û×°ÁËvs2008£¬ÔÙ×°sqlserver2005ºÃÏñÓÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ