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

ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005

 
ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005
 
Ò»¡¢Òª½øÐÐÁ½¸öµØ·½µÄÉèÖÃ
1         µã¿ªÊ¼—³ÌÐò—sql server 2005 –ÅäÖù¤¾ß—sql server 2005Ó¦ÓÃÅäÖÃÆ÷ ,Èçͼ£º
 
 
 
Ñ¡±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½ÓÖеĠ ½öʹÓÃtcp/ip»ò  ͬʱʹÓÃtcp/ipºÍnamed pipes
2         µã¿ªÊ¼—³ÌÐò—sql server 2005—ÅäÖù¤¾ß—sql server configuration manger
 
 
ЭÒéÑ¡ ·ñ·ñÊÇ,Ò²¾ÍÊÇÈ«²¿ÕìÌýÑ¡·ñ¡¢ÒÑÑÓ³ÙÑ¡·ñ¡¢ÒÑÆôÓÃÑ¡ÊÇ¡£È»ºóÔÙÑ¡ipµØÖ·Ñ¡Ïî
 
 
 
ÈçͼÓÐÁ½¸öipµØÖ·£¬Ò»¸öÊÇ127.0.0.1,ÁíÒ»¸öÊÇÄãÒªÅäÖõģ¬ÎªÄã»úÆ÷ÉϵÄip µØÖ·£¬tcp¶¯Ì¬¶Ë¿ÚΪ¿Õ£¬tcp¶Ë¿ÚΪ£º1433£¬ÒÑÆôÓãºÊÇ¡£
IPµØÖ·¿ÉÒÔÓÃDOSÖеÄIPCONFIGÃüÁîÀ´²é¿´¡£
µã¿ªÊ¼—ÔËÐЗcmd,È»ºóÔÚDOSÃüÁîÌáʾ·ûÏÂÊäÈëIPCONFIG¡£Èçͼ¡£
 
 
¶þ   ÉÏÃæÁ½¸ö²½ÖèÉèÖúúó£¬Èç¹ûÄãµÄ»úÆ÷ÉÏÓжà¸ösql serverÊý¾Ý¿â£¬×îºÃÒª½«ÆäËûµÄÍ£Ö¹£¬ÒÔ·ÀÖ¹ÕùÓÃ1433¶Ë¿Ú¡£
 
Èý£¬ ÖØÆô  sql server 2005·þÎñ¡£
È»ºó£¬ÄãÒ²¿ÉÒÔÔÚDOSÏÂÊÔÊÔ£¬´ÓÄãµÄ»úÆ÷ºÍÁíÒ»¸ö»úÆ÷·Ö±ðÊÔÊÔÒÔϵÄDOSÃüÁ
TELNET 192.168.3.138 1433  
ÆäÖÐTELNETºóÃæµÄΪÄãSQL SERVER2005»úÆ÷ÉϵĵÄIPµØÖ·¡£Èç¹û³öÏÖºÚÆÁ£¬¹§Ï²Äã³É¹¦À²¡£³ö¹û³öÏÖÏÂÃæµÄ´íÎóÌáʾ£¬ÇëÔÙ¿´¿´ÉÏÃæµÄÉèÖÃÊDz»Êdzö³öÁËÎÊÌâ¡£
 
 
 
 ËÄ ×î½üÒ»²½ÊǵǼ£º
 
 


Ïà¹ØÎĵµ£º

Java Á¬½ÓÊý¾Ý¿â¡¢Ö´ÐÐSQL·â×°Àà

/*µ±Ö´ÐÐSQLʱ·¢ÏÖ²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬ÏÈÖØÁ¬Ò»´Î*/
 
import java.io.FileInputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
......

SQL Server2005 SynonymµÄʹÓÃ

--> Title  : SQL Server2005 SynonymµÄʹÓÃ
--> Author : wufeng4552
--> Date   : 2009-10-30
1.SynonymµÄ¸ÅÄî
¡¡  Synonym£¨Í¬Òå´Ê£©ÊÇSQL Server 2005µÄÐÂÌØÐÔ¡£¿ÉÒÔ¼òµ¥µÄÀí½âSynonymΪÆäËû對ÏóµÄ±ðÃû¡£
語·¨
CREATE SYNONYM [ schema_name_1. ] synonym_name FOR & ......

sql´æ´¢¹ý³ÌÓï·¨

 
Ò».×¢ÊÍ
  -- µ¥ÐÐ×¢ÊÍ£¬´ÓÕâµ½±¾ÐнáÊøÎª×¢ÊÍsql Óï·¨£¬ÀàËÆC++£¬c#ÖÐ//
  /* ¡­ */ ¶àÐÐ×¢ÊÍ£¬ÀàËÆC++£¬C#ÖÐ/* ¡­ */

¶þ.±äÁ¿£¨int£¬ smallint£¬ tinyint£¬ decimal£¬float£¬real£¬ money £¬smallmoneysql Óï·¨£¬ text £¬image£¬ char£¬ varchar¡£¡£¡£¡£¡£¡££©
Óï·¨£º
DECLARE
&nb ......

SQL Server 2005 EXCEPTºÍINTERSECTÔËËã·û


--> Title  : SQL Server 2005EXCEPTºÍINTERSECTÔËËã·û
--> Author : wufeng4552
--> Date   : 2009-10-30
 
(Ò»)¸ÅÄî
EXCEPTºÍINTERSECTÔËËã·ûʹÄú¿ÉÒԱȽÏÁ½¸ö»ò¶à¸öSELECTÓï¾äµÄ½á¹û²¢·µ»Ø·ÇÖØ¸´Öµ¡£
(¶þ)區別
EXCEPTÔËËã·û·µ»ØÓÉEXCEPTÔËËã·û×ó²àµÄ²éѯ·µ»Ø¡¢¶øÓÖ² ......

JSPÖÐÁ¬½ÓSQL 2000Êý¾Ý¿âµÄÎÊÌâ×ܽá

 
ÓÉÓÚϵͳÐèÇó£¬×î½üÔÚ¿ª·¢¹ý³ÌÖн«ÏµÍ³´ÓÔ­À´µÄMySQL×ªÒÆµ½SQL
2000Ï£¬ÆäÖÐÓöµ½ÁËÖî¶àÎÊÌ⣬»¨·ÑÁËÎÒ²»ÉÙʱ¼ä¡£ÏÖÔÚ°ÑÎҵľ­ÑéÄóöÀ´¸æËß´ó¼Ò£¬ºÃÈôó¼ÒÉÙ×ßÍä·£¬½ÚԼʱ¼ä¡£
¡¡¡¡Ê×ÏÈÊÇSQL
2000Êý¾Ý¿âµÄ°²×°ÎÊÌ⣬ÔÚ´ËÎÒÖ÷Òª½²Ð©¹ØÓÚSQL 2000µÄ°æ±¾Óë²Ù×÷ϵͳµÄ¼æÈÝÐÔÎÊÌ⣺SQL
2000×ܹ²ÓÐ7¸ö²»Í¬°æ±¾£¬ÊÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ