Êý¾Ý¿âSQL2005£¬Î´½øÐйýÈκÎÉý¼¶
ÒÔǰºÃºÃµÄ£¬×î½üÒ»¸öÐÇÆÚÒÔÀ´£¬
Ö»ÒªÒ»´ò¿ªSQL Server Management Studio£¬
ÄÇôͨ¹ý¿Í»§¶Ë½øÐÐËùÓвÙ×÷£¨Ôöɾ¸Ä²é£©ËÙ¶È»á±äµÄÌØ±ðÂý£¬ÄÄÅÂ×î¼òµ¥µÄ²éѯҲÂýµÄÒªËÀ£¬
ÔÚSQL Server Management StudioÖÐÖ´ÐÐSQLÓï¾äҲͬÑùÂý£¬
Ö»ÒªÒ»¹ØµôSQL Server Management StudioËÙ¶ÈÁ¢¼´¾Í¿ìÆðÀ´£¬
²»ÖªµÀÊÇʲôÔÒò£¬Çë¸÷λ°ï°ïæ
ɾ³ý֨װÊÔÊÔ
³ÌÐòÖж¾ÁË£¿
Ŀǰ¿ÉÒԿ϶¨µØÅųýÖж¾»òÖÐľÂíµÄÔÒò£¬ÊµÔÚ²»Ïë֨װ°¡£¬×Ü»áÓÐÔÒòµÄ°É£¬ÓôÃÆ
ÒýÓà Êý¾Ý¿âSQL2005£¬Î´½øÐйýÈκÎÉý¼¶ ÒÔǰºÃºÃµÄ£¬×î½üÒ»¸öÐÇÆÚÒÔÀ´£¬ Ö»ÒªÒ»´ò¿ªSQL Server Management Studio£¬ ÄÇôͨ¹ý¿Í»§¶Ë½øÐÐËùÓвÙ×÷£¨Ôöɾ¸Ä²é£©ËÙ¶È»á±äµÄÌØ±ðÂý£¬ÄÄÅÂ×î¼òµ¥µÄ²éѯҲÂýµÄÒªËÀ£¬ ÔÚSQL Server Management StudioÖÐÖ´ÐÐSQLÓï¾äҲͬÑùÂý£¬ Ö»ÒªÒ»¹ØµôSQL Server Management StudioËÙ¶ÈÁ¢¼´¾Í¿ìÆðÀ´£¬ ²»ÖªµÀÊÇʲôÔÒò£¬Çë¸÷λ°ï°ïæ ûÓöµ½ÕâÖÖÇé¿ö,°ï¶¥.
´òÉÏ2005µÄ²¹¶¡ÊÔÊÔ
ÊÔÊÔsp3µÄ²¹¶¡
лл¸÷λ
ÎÊÌâ½â¾ö
ÕæÊÇÓеã¼ú£¬²»ÌáÎʾͲ»Ô¸Òâ×ÐϸµØ²éÔÒò£¬
ºÇºÇ
½â¾ö°ì·¨ÈçÏ£º
ÔÚÅäÖùÜÀíÆ÷ÖУ¨SQL Server Configuration Manager)£¬
SQL Server2005 ÍøÂçÅäÖÃ-->SQL2005 µÄÐÒ飬
²»ÖªµÀʲôʱºòÖ»¿ªÆôÁËÒ»¸öÐÒ飨Shared Memory),
TCP/IPÐÒ龹Ȼ먦Æô
È»ºó¿ªÆôÁËTCP/IP¼°ÃüÃû¹ÜµÀ£¬
ÎÊÌâ½â¾ö
лл´ó¼ÒÁË
´òSP3²¹¶¡
ÒýÓÃ
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö ÀýÈç procedure produce_proc @p001 nvarchar(8000), @p002 nvarchar(8000), @p003 nvarchar(8000), & ......
СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´ °à¼¶±í ½Ìʦ±í °à¼¶ID & ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿ try { connection.connect() return true; } catch() { return false; } Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£ ÒýÓà try { connection.connect( ......