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

¹ØÓÚSQLÊý¾Ý¿âÎÞ·¨Ô¶³ÌµÇ½

»·¾³£º
ÎҵĵçÄÔ×°XPϵͳ¼°SQL·þÎñÆ÷£¬ÎҵĵçÄÔÊÇË«Íø¿¨£¬IPΪ192.168.0.10£¨ÄÚÍø£©£¬192.168.1.29£¨ÍâÍø£©£¬ÆäÖÐ192.168.0.10Õâ¸öIPΪÄÚÍøIP£¬Í¬Ê±µçÄÔÒ²¼ÓÈëÁËSHÓò£¬µ±ÎÒ°Ñ192.168.1.29Õâ¿éÍø¿¨¹Ø±Õµôºó£¬ÔÚÓòÖÐÆäËüµçÄÔ¶¼ÄÜÔ¶³Ì·ÃÎÊÎÒµÄSQL SERVER£¬ÎÒÒ²ÄÜͨ¹ý²éѯ·ÖÎöÆ÷·ÃÎÊÆäËüµçÄÔÉϵÄSQL SERVER¡£
ÁíÒ»ÖÖÇé¿öµ±ÎÒ°Ñ192.168.0.10Õâ¿éÍø¿¨¹Ø±Õµôºó£¬ÔÚ192.168.1Õâ¸öÍø¶ÎÖеĵçÄÔ¶¼ÎÞ·¨»¥Ïà·ÃÎÊSQL SERVER£¬£¨ÎÒÎÞ·¨·ÃÎÊÆäËüµçÄÔµÄSQL SERVER£¬ÆäËüµçÄÔÒ²ÎÞ·¨Í¨¹ý·ÖÎö²éѯÆ÷À´Á¬½ÓÎÒµÄSQL SERVER£©¡£
ÎÒµçÄÔµÄ1433¶Ë¿ÚÒѾ­´ò¿ª£¨Ó÷À»ðǽ¿ª·ÅµÄ¶Ë¿Ú£©
ÎÒ²»ÖªµÀÎÊÌâµ½µ×³öÔÚÄÄÀïÁË£¬ÎÒÒ²ÖØÐÂ×°Á˲Ù×÷ϵͳ¡£ÇëÖªµÀµÄÅóÓѰïæһÏ£¬Ð»Ð»£¡

192.168.0.10£¨ÕâÊÇ192.168.0Íø¶Î£©
192.168.1.29£¨ÕâÊÇ192.168.1Íø¶Î£©
Ó¦¸Ã²»ÔÚͬһ¸öIPµØÖ·¶Î°¡£¬ÇÒÁ½¸öÍø¶ÎÊÇÎïÀí·Ö¿ªµÄ

ÏÈÈ·ÈÏÊÇ·ñÄÜ PING ͨ¡£

¿ÉÒÔpingͨ


ÒýÓÃ
192.168.0.10£¨ÕâÊÇ192.168.0Íø¶Î£©
192.168.1.29£¨ÕâÊÇ192.168.1Íø¶Î£©
Ó¦¸Ã²»ÔÚͬһ¸öIPµØÖ·¶Î°¡£¬ÇÒÁ½¸öÍø¶ÎÊÇÎïÀí·Ö¿ªµÄ

ÄãÊ×ÏÈÓÃ192.167ÊÔÊÔ

telnet 192.168.1.29 1433  ÎÞ·¨Á¬½ÓÖ÷»ú
telnet yangjinfei 1433  ÎÞ·¨Á¬½ÓÖ÷»ú
telnet yjf 1433 ÄÜÁ¬ÉÏ

¼ÆËã»úÐÅÏ¢£º
ÍêÕûµÄ¼ÆËã»úÃû³Æ£ºyangjinfei@sh.com
Óò£º              sh.com
µÇ½Óû§ÃûΪ:yjf



ÄãÏÖÔÚ×Ô¼ºµÄ£Ð£ÃµÄ£É£ÐÊǶàÉÙ£¿

192.168.1.29

ÎÊÌâµÃÒÔ½â¾ö£¬Ô­À´²Ù×÷ϵͳµÄÎÊÌ⣬ÎÒ°Ñϵͳ»»³ÉÒ»²½²½°²×°µÄ¾ÍÐÐÁË£¬Ô­ÏÈÓõ


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sql´æ´¢¹ý³Ìʱ¼äÏà¼õ - MS-SQL Server / »ù´¡Àà

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql=''
if (@username<>null and @username ......

sql server - Java / Eclipse

Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....

ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡

½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......

sql like ²éѯ - MS-SQL Server / ÒÉÄÑÎÊÌâ


Ò»¡¢7|3|1,8|6|1,3|1|1,16|1|1,5|7|1,9|7|1
¶þ¡¢6|3|1,7|3|1,8|6|1,2|1|1,3|1|1,16|1|1,4|7|1,5|7|1,9|7|1,10|7|1,11|4|1,12|4|1,13|4|1,14|5|1,15|5|1,17|0|1
ÔõÑù²éѯ Ò» ÔÚ ¶þ ÀïÃæ²¢Êä³ö¼Ç¼¼¯¡£
SQL code: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ