ÈçºÎÅäÖà SQL Server 2005 ÒÔÔÊÐíÔ¶³ÌÁ¬½Ó
½ñÌìÔÚÒ»¸öVPSÉÏ°²×°sql2005£¬°²×°ºÃºó±¾µØÒ»Ö±Á¬½Ó²»ÉÏ
¼ò½é
ÔÚ³¢ÊÔ´ÓÔ¶³Ì¼ÆËã»úÁ¬½Óµ½ Microsoft SQL Server 2005 ʵÀýʱ£¬¿ÉÄÜ»á½ÓÊÕµ½´íÎóÏûÏ¢¡£ÔÚʹÓÃÈκγÌÐòÁ¬½Óµ½ SQL Server ʱ¶¼¿ÉÄܻᷢÉú´ËÎÊÌâ¡£ÀýÈ磬ÔÚʹÓà SQLCMD ʵÓù¤¾ßÁ¬½Óµ½ SQL Server ʱÊÕµ½ÒÔÏ´íÎóÏûÏ¢£º
Sqlcmd:´íÎó:Microsoft SQL Native Client:½¨Á¢µ½·þÎñÆ÷µÄÁ¬½Óʱ·¢Éú´íÎó¡£Á¬½Óµ½ SQL Server 2005 ʱ£¬Ä¬ÈÏÉèÖà SQL Server ²»ÔÊÐíÔ¶³ÌÁ¬½ÓÕâ¸öÊÂʵ¿ÉÄܻᵼÖÂʧ°Ü¡£
Èç¹ûûÓн« SQL Server 2005 ÅäÖÃΪ½ÓÊÜÔ¶³ÌÁ¬½Ó£¬Ôò¿ÉÄܻᷢÉú´ËÎÊÌ⡣ĬÈÏÇé¿öÏ£¬SQL Server 2005 Express Edition ºÍ SQL Server 2005 Developer Edition ²»ÔÊÐíÔ¶³ÌÁ¬½Ó¡£ÈôÒªÅäÖà SQL Server 2005 ÒÔÔÊÐíÔ¶³ÌÁ¬½Ó£¬ÇëÍê³ÉÒÔÏÂËùÓв½Ö裺
ÔÚÄúÒª´ÓÔ¶³Ì¼ÆËã»úÁ¬½Óµ½µÄ SQL Server ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó¡£
´ò¿ª SQL Server Browser ·þÎñ¡£
ÅäÖ÷À»ðǽÒÔÔÊÐíÓë SQL Server ºÍ SQL Server Browser ·þÎñÏà¹ØµÄÍøÂçͨѶ¡£
±¾ÎĽéÉÜÈçºÎÍê³ÉÕâЩ²½ÖèÖеÄÿһ²½¡£
ÈôÒªÔÚ SQL Server 2005 ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó²¢´ò¿ª SQL Server Browser ·þÎñ£¬ÇëʹÓà SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷¹¤¾ß¡£ÔÚ°²×° SQL Server 2005 ʱ»á°²×°ÍâΧӦÓÃÅäÖÃÆ÷¹¤¾ß¡£
Ϊ SQL Server 2005 Express Edition »ò SQL Server 2005 Developer Edition ÆôÓÃÔ¶³ÌÁ¬½Ó
< type="text/javascript"> ±ØÐëΪҪ´ÓÔ¶³Ì¼ÆËã»úÁ¬½Óµ½µÄÿ¸ö SQL Server 2005 ʵÀýÆôÓÃÔ¶³ÌÁ¬½Ó¡£Îª´Ë£¬Çë°´ÕÕÏÂÁв½Öè²Ù×÷£º
µ¥»÷“¿ªÊ¼”£¬ÒÀ´ÎÖ¸Ïò“³ÌÐò”¡¢“Microsoft SQL Server 2005”ºÍ“ÅäÖù¤¾ß”£¬È»ºóµ¥»÷“SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”¡£
ÔÚ“SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷”Ò³ÉÏ£¬µ¥»÷“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”¡£
ÔÚ“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”Ò³ÉÏ£¬Õ¹¿ª“Êý¾Ý¿âÒýÇ攣¬ÒÀ´Îµ¥»÷“Ô¶³ÌÁ¬½Ó”ºÍ“±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”£¬µ¥»÷ÊÊÓÃÓÚÄúµÄ»·¾³µÄÏàÓ¦ÐÒ飬Ȼºóµ¥»÷“Ó¦ÓÔ¡£
×¢Ò⣺ÇëÔÚ½ÓÊÕµ½ÒÔÏÂÏûϢʱµ¥»÷“È·¶¨”£º
Ö±µ½ÖØÐÂÆô¶¯Êý¾Ý¿âÒýÇæ·þÎñºó£¬¶ÔÁ¬½ÓÉèÖÃËù×öµÄ¸ü¸Ä²Å»áÉúЧ¡£
ÔÚ“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”Ò³ÉÏ£¬Õ¹¿ª“Êý¾Ý¿âÒýÇ攣¬ÒÀ´Îµ¥»÷“·þÎñ”ºÍ“Í£Ö¹”£¬µÈ´ý MSSQLSERVER ·þÎñÍ£Ö¹£¬È»ºóµ¥»÷“Æô¶
Ïà¹ØÎĵµ£º
×òÌìÔÚ½«Ò»¸ö SQL Server 2000 Êý¾Ý¿â¸½¼Óµ½ SQL Server 2008 ʱ³öÏÖÈçϵĴíÎó£º
¸½¼ÓÊý¾Ý¿â ¶ÔÓÚ ·þÎñÆ÷“servername”ʧ°Ü¡£ (Microsoft.SqlServer.Smo)
ÎÞ·¨Éý¼¶Êý¾Ý¿â ‘dbname’£¬ÒòΪËüÊÇÖ»¶ÁµÄ£¬»òÕß¾ßÓÐÖ»¶ÁÎļþ¡£Ç뽫Êý¾Ý¿â»òÎļþÉèΪ¿Éд£¬È»ºóÖØÐÂÔËÐлָ´²Ù×÷¡£ (Microsoft SQL S ......
Êý¾Ý¿â²Ù×÷Àࣺ
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
/// <summary>
/// È¡µÃ×ÜÊý
/// </summary>
/// <returns></returns>
public string getTotal()
{
StringBuilder sb = new StringBuilder();
sb.Append("select count(*) total from Test");
DataTable dt = DBHelper.ExecuteDt(sb.ToString ......
ÔÚwindows XP SP3 ÖÐÊÇ¿ÉÒÔ°²×° SQL Server 2005 µÄ²»»áÓмæÈÝÎÊÌâ ÎÒÔÚ°²×°µÄʱºò¾ÍʲôÎÊÌⶼû¿´µ½ °²×°ºÃºó¸½¼ÓÒ»¸öÊý¾Ý¿â ÓÃBorland JBuilder 2006 Enterprise ºÍeclipse ҲûÎÊÌâ
SQL2005 ·ÖÎå¸ö°æ±¾£¬ÈçÏÂËùÁУ¬
¡¡¡¡1.Enterprise(ÆóÒµ°æ),
2.Development(¿ª·¢°æ),
¡¡¡¡3.Workgroup,(¹¤×÷Ⱥ°æ)
¡¡¡¡4.St ......
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
¡¡¡¡ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
¡¡¡¡ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌâ×î´óÁË£¬Óбð ......
¸Õ×°ÍêÊý¾Ý¿â¾Í±»ÈË·è¿ñɨÃèsa£¬ÎÞ±ÈÓôÃÆ¡£
¸ÄsaÃû³Æ£¬1433¶Ë¿ÚºÅ£¬ÒòΪ¿ª·¢ÐèÒª»¹±ØÐë´ò¿ªÔ¶³ÌÁ¬½Ó£¬½á¹ûÔÚ¿Í»§¶ËÎÞÂÛÈçºÎ¶¼²»ÄÜÁ¬½ÓÉÏ·þÎñÆ÷¡£
¿ñº¹Çë°Ù¶È´óÉñ³öÂí£¬°Ñ¸÷ÖÖÅäÖÃÁ·Á˸öÊ죬½á¹û»¹ÊÇû½â¾ö¡£
¸ãЦµÄÊÇ×îºóÎÞÒâÖÐÔÚMicrosoftÂÛ̳ÉÏ¿´µ½Õâôһ¾ä£¬ÐÞ¸ÄÍê¶Ë¿ÚºÅ£¬ÔÚ¿Í»§¶ËµÇ¼µÄʱºòÒªÔÚIPºóÃ棫¶ººÅ£«¶Ë¿Úº ......