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"
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËÆµÄÖµ£¬ÎÒÐèÒª½«Æä ......
лл
SQL code:
exec sp_lock --¿´ objId
È»ºóÓÃ
select object_name(ObjID)
ÒýÓÃ
SQL codeexec sp_lock--¿´ objId
È»ºóÓÃselectobject_name(ObjID)
ÎÒÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ,Ôõô²»ÄÜÖ´ÐÐÄØ? ......
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......