Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 nullµÄÎÊÌâ

´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......

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

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

identity?ɶÒâ˼£¿

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

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

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ºÅ