¼ÙÈçÔÚÄãµÄµçÄÔ›]Óа²ÑbSQLµÄÇéÐÎÏ£¬ÓÐһЩӦÓÃÈí¼þÔÚÓ¦ÓÃOLEDB¡¢ADOÁ¬½ÓÊý¾Ý¿â´æµÄÇé¿öÏÂSQLNCLI.1û·¨ÔË×÷£¬ÄÇÑùÈËÃǾͿÉÒÔ¸ù¾Ý°²Ñbsqlncli.msiÀ´´¦ÀíÕâ¸öÎÊÌâÁË¡£

ÒòΪÕâ½ö½öMicrosoftSQLServerNativeClientµÄÒ»²¿·Ö·ÖÀë³öÀ´µÄÊÖ»ú¿Í»§¶Ë²¿¼þ£¬±ØÐëµÄºÃÅóÓÑ»¹ÐèÒª°²ÑbÏàÆ¥ÅäµÄ°æ±¾ºÅ¡£

¡¾APPÌص㡿

SQLServer2008R2ÒýÈëÁËһϵÁÐÐÂ×÷ÓÃЭÖú¸÷ÖÖ¸÷Ñù¾­Óª¹æÄ£µÄÒµÎñÁ÷³Ì´ÓÐÅÏ¢ÄÚÈÝÖлñµÃ´óÁ¿Ê¹ÓüÛÖµ¡£¸ÄÉƵÄSQLServer2008R2Ìá¸ßÁË¿ª·¢Éè¼Æ¹¤×÷ÄÜÁ¦£¬ÌáÉýÁ˿ɹÜÀíÐÔ£¬¼ÓÇ¿ÁËÉÌÎñÖÇÄܼ°Êý¾Ý¿â¹ÜÀí¡£

ʹÓ÷½·¨

1¡¢ÌôÑ¡²Ëµ¥À¸ÖгÌÐòÁ÷³Ì¡¾ManagementSQLServer2008¡¿¡¾SQLServerManagementStudio¡¿Ö¸Á¿ªÆô¡¾SQLServerManagementStudio¡¿¶Ô»°¿ò£¬²¢Ó¦ÓÃwindows»òSQLServerÉí·ÝÈÏÖ¤´´½¨Áª½Ó£»

2¡¢ÔÚ¡¾Ä¿±êÈÎÎñ¹ÜÀíÆ÷¡¿¶Ô»°¿òÖнøÐÐÍøÂç·þÎñÆ÷£¬ËæºóÌôÑ¡¡¾Êý¾Ý¿â¡¿Á¬½Óµã£»

3¡¢ÓÒ¼üµ¥»÷¡¾Êý¾Ý¿â¡¿Á¬½Óµã£¬´Óµ¯³ö´°¿ÚµÄ¿ì¼ü²Ëµ¥ÖÐÑ¡Ôñ¡¾Ð½¨Êý¾Ý¿â¡¿Ö¸Áî¡£

4¡¢ÊµÐÐÒÔÉÏʵ¼Ê²Ù×÷ºó£¬»áµ¯³öÀ´¡¾Ð½¨Êý¾Ý¿â¡¿¶Ô»°¿ò¡£ÔÚ¶Ô»°¿ò¡¢×ó±ßÓÐ3¸öÑ¡Ï·Ö±ðÊÇ¡¾»ù±¾¡¿¡¢¡¾Ñ¡Ïî¡¿ºÍ¡¾Îļþ×é¡¿¡£½øÐÐÕâÈý¸öÑ¡ÏîÖеÄÉ趨»áÒéºó£¬¾ÍÍê³ÉÁËÊý¾Ý¿âµÄ½¨Á¢¹¤×÷ÖС£

5¡¢ÔÚ¡¾Êý¾Ý¿âÃû×Ö¡¿ÊäÈë¿òÖмüÈëҪн¨Êý¾Ý¿âµÄÃû×Ö¡£±ÈÈ磬Õâ¶ùÒÔн¨µÄÊý¾Ý¿â¡£

6¡¢ÔÚ¡¾Ê¹ÓÃÕß¡¿ÊäÈë¿òÖмüÈëн¨Êý¾Ý¿âµÄʹÓÃÕߣ¬Èçsa¡£ÒÀ¾ÝÊý¾Ý¿âµÄÔËÓÃ×´¿ö£¬ÌôÑ¡¿ªÆô»òÊǽûֹʹÓá¾Ó¦ÓÃÈ«ÎÄË÷Òý¡¿¹´Ñ¡¿ò¡£

7¡¢ÔÚ¡¾Êý¾Ý¿âÎļþ¡¿Ä¿Â¼Öаüº¬¶þÐУ¬Ò»ÐÐÊÇÊý¾Ý¿âÎļþ£¬¶øÁíÒ»ÐÐÊÇÈÕ¼ÇÎļþ¡£¸ù¾Ýµã»÷ϱߵġ¾¼ÓÉÏ¡¿¡¢¡¾É¾µô¡¿°´¼ü¼ÓÉÏ»òɾµôÊý¾Ý¿âÎļþ¡£

8¡¢×ª»»µ½¡¾Ñ¡ÏîÒ³¡¿¡¢ÔÚÕâ¶ù¿ÉÒÔÉ趨Êý¾Ý¿âµÄÅÅÁбê×¼¡¢»Ö¸´Ä£Ê½¡¢¼æÈݵȼ¶ºÍ±ðµÄÌØÐÔ¡£

9¡¢×ª»»µ½¡¾Îļþ×é¡¿Ò³£¬ÔÚÕâ¶ù¿ÉÒÔ¼ÓÉÏ»òɾµôÎļþ×é¡£

10¡¢½øÐÐÒÔÉÏʵ¼Ê²Ù×÷ºó£¬µã»÷¡¾Ã÷È·¡¿°´¼ü¹Øµô¡¾Ð½¨Êý¾Ý¿â¡¿¶Ô»°¿ò¡£ÖÁ´Ëн¨µÄÊý¾ÝÐÅÏ¢Êý¾Ý¿â½¨Á¢È¡µÃ³É¹¦¡£Ð½¨µÄÊý¾Ý¿â¿ÉÒÔÔÙ¡¾Ä¿±êÈÎÎñ¹ÜÀíÆ÷¡¿¶Ô»°¿ò¼ûµ½¡£