¹ØÓÚSQLserverÁ¬½ÓµÄÎÊÌâ
ÎÒ×°ÁËSQLserver2000¡¢SQLserver2005ÕâÁ½¸öÊý¾Ý¿â£¬ÔõôÁ¬½ÓÕâÁ½¸öÊý¾ÝÄØ£¿£¨¿ª·¢¹¤¾ßΪmyEclipse£©
ÎÒÓÃJDBCÁ¬½ÓÉÏÁËSQLserver2005,¼ÓÈëÁËÈý¸öÇý¶¯°ü(Ìý˵ÕâÈý¸öÇý¶¯ÊÇÓÃÓÚÁ¬½ÓSQLserver2000µÄ)£¬Çý¶¯ÃûΪcom.microsoft.jdbc.sqlserver.SQLServerDriver£¬½á¹ûÁ¬½ÓÉÏÁË
Èç¹ûÎÒÏëÁ¬½ÓSQLserver2000ÔõôÁ¬ÄØ£¿Çý¶¯ÓÃʲô£¿
PS£º±¾È˳õѧÕߣ¬Çë½ÌÁ¬½ÓÊý¾Ý¿âÓм¸ÖÖ·½Ê½ÄØ£¿
2000 or 2005µÄÁ´½Ó¼Ü°ü£¬Äã¶¼¿ÉÒÔֻʹÓÃSQL2005µÄÁ´½Ó¼Ü°ü£¬Ö»ÐèÒªÒ»¸ö¼´¿É£¡sqljdbc.jar
Çý¶¯²»Í¬£¬¼ÓÔØÇý¶¯Ê±Ò²ÓÐЩ²»Í¬£º
2005£º
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Á¬¿â×Ö·û´®"jdbc:sqlserver://localhost:1433;databaseName=**"
2000:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Á¬½Ó×Ö·û´®"jdbc:microsoft:sqlserver://localhost:1433;databaseName=**"
ͬʱ°²×°SQLserver2000¡¢SQLserver2005ÕâÁ½¸öÊý¾Ý¿âµÄʱºò£¬Òª×¢ÒâÁ½¸öÊý¾Ý¿âÊǵĶ˿ںŲ»ÄÜÏàͬ£¬
Çø·ÖSQLserver2000»¹ÊÇSQLserver2005
JDBCÁ´½ÓSQLserverʱºò¿ÉÒÔ¸ù¾Ý¶Ë¿Ú²»Í¬À´Çø·Ö
2Â¥Õý½â£¡£¡£¡£¡£¡£¡
¸øµã·Ö°É
ÎÒ¶¥Äã
»Ø¸´ÄÚÈÝÌ«¶ÌÁË
2005£º
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Á¬¿â×Ö·û´®"jdbc:sqlserver://localhost:1433;databaseName=**"
2000:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Á¬½
Ïà¹ØÎÊ´ð£º
PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶ ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......