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

JDBCÁ¬½Ómicrosoft sqlserverÒªÔõôÁ¬°¡

ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè

Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´

Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....

netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶Ë¿Ú

°²×°sqlserver
´ò²¹¶¡
Æô¶¯·þÎñ
µ¼ÈëÇý¶¯°ü


sqlserver ´ò²¹¶¡µ½sp4 ÊÇ×îºÃµÄ£¡
ÏÂÀ´Êǵ¼ÈëÇý¶¯°ü£¡
дÁ´½ÓÀà ´¦ÀíÒì³£
²âÊÔ£¡

Â¥Ö÷°ÑÄãµÄ´úÂëÌù³öÀ´¿´¿´£¬»òÕß±¨´í£¬lsµÄ·½·¨¿ÉÒÔ´¦Àí

¶àÊÇδ°²×°sqlserverµÄ²¹¶¡°ü£¬½¨Òé¶àGOOGLE

Â¥Ö÷ÉϰٶȻòÕßgoogle¿´¿´°É£¡

Òª¿´ÄãÁ¬½ÓµÄÊÇsqlserver2000£¬»¹ÊÇsqlserver2005.
ÕâÁ½¸öÓõÄJDBC°üÊDz»Í¬µÄ¡£
sqlserver2000ÓÃmsbase.jar,mssqlserver.jar,msutil.jarÈý¸ö°ü
sqlserver2005ÓÃsqljdbc.jarÒ»¸ö°ü
°ÑÏàÓ¦µÄ°ü·ÅÈëclasspath,È»ºóÉ趨TCP¶Ë¿Ú£¬2005µÄ»°»¹ÒªÉ趨SQLServerBrowser£¬
×îºóÔÚ³ÌÐòÖÐÓÃÒÔÏ´úÂëÁ¬
Driver d =
(Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password");

×¢Òâ
2000ÓÃcom.microsoft.jdbc.sqlserver.SQLServerDriverºÍ
      jdbc:microsoft:sqlserver://localhost:1433", "userName", "password"
2005ÓÃcom.microsoft.sqlserver.jdbc.SQLServerDriverºÍ
      jdbc:sqlserver://localhost:1433", "userName"


Ïà¹ØÎÊ´ð£º

Ö±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð

sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã

²»Ã÷°×~~~

Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹Ô­Êý¾Ý¿â

Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

¼±£¬sqlserver½ø²»È¥ÁË£¿[

ûÁ¬½ÓÍøÏߣ¬ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
±¾µØ²»ÄܵǼÂð£¿.......

ÒýÓÃ
±¾µØ²»ÄܵǼÂð£¿.......
ÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄ

Óà windowsÉí·ÝÒ²²»ÄܵǼÂð£¿

ÄãÁ¬½Óµ ......

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

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

ÈçºÎ°ÑmysqlÀïµÄÊý¾Ýµ¼Èëµ½sqlserverÀ

ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ