ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“°²È«ÐÔ”£¬ÔÚ“·þÎñÆ÷Éí·ÝÑéÖ¤”ÀïÑ¡Ôñ“SQL ServerºÍWindows Éí·ÝÑé֤ģʽ”£¬µ¥»÷“È·¶¨”£¬Íê³É¡£
È»ºóÌí¼ÓÒ»¸öеĵǽÃûºÍÃÜÂë
1´ò¿ªSQL Server Management Studio
2Ñ¡Ôñ“°²È«ÐÔ→µÇ¼Ãû”£¬ÓÒ»÷“µÇ¼Ãû”£¬Ñ¡Ôñ“н¨µÇ¼Ãû”£¬´ò¿ª“µÇ¼Ãû-н¨”¶Ô»°¿ò£¬ÔÚ“³£¹æ”Ñ¡ÏÖУ¬ÊäÈëµÇ¼Ãû£¬Èç“aaa”,Ñ¡Ôñ“SQL Server Éí·ÝÑéÖ¤”£¬ÊäÈëÃÜÂëºÍÈ·ÈÏÃÜÂ룬ȥµô“Ç¿ÖÆʵʩÃÜÂë²ßÂÔ”¡¢“Ç¿ÖÆÃÜÂë¹ýÆÚ”¡¢“Óû§ÔÚÏ´εǼʱ±ØÐë¸ü¸ÄÃÜÂë”Ç°µÄ¹´£¬Ñ¡ÔñĬÈÏÊý¾Ý¿â£¬Ä¬ÈÏÓïÑÔÑ¡Ôñ“Simplified Chinese”
3Ñ¡Ôñ“·þÎñÆ÷½ÇÉ«”Ñ¡Ï£¬Ñ¡Ôñ“sysadmin”£¬·þÎñÆ÷½ÇÉ«Ãû½âÊÍ¿´SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â¡£
4Ñ¡Ôñ“Óû§Ó³Éä”Ñ¡Ï£¬Ñ¡ÔñÒªÇóµÄÊý¾Ý¿â£¬¸ù¾Ý¸öÈËÒªÇó¶àÑ¡»òÊǵ¥Ñ¡¡£
5Ñ¡Ôñ“״̬”Ñ¡Ï£¬“ÉèÖÔÀï“ÊÇ·ñÔÊÐíÁ¬½Óµ½Êý¾Ý¿âÒýÇæ”Ñ¡Ôñ“ÊÚÓ蔣¬“µÇ¼”ÀïÑ¡Ôñ“ÆôÓÔ£¬µ¥»÷“È·¶¨”£¬Íê³É¡£
×îºóÍ˳ö·þÎñÆ÷£¬ÓÃн¨µÄµÇ¼Ãû“aaa”µÇ¼·þÎñÆ÷£¬³É¹¦£¡
ÇмǣºÒ»¶¨Òª°ÑSQL Server 2005 ·þÎñÖØÆô²ÅÉúЧ
ÈçºÎÖØÆôSQL Server 2005 ·þÎñ£¿
´ò¿ª‘¿ªÊ¼’£‘ËùÓгÌÐò’£‘Microsoft SQL Server 2005 ’£‘ÅäÖù¤¾ß’£‘SQL Server ÅäÖùÜÀíÆ÷’(SQL Server Configuration Manager)£¬Ñ¡Ôñ“SQL Server 2005 ·þÎñ”£¬¿ÉÒÔÔÚÓÒ±ßÓÒ»÷Ñ¡ÔñÐèÒªÖØÆôµÄ·þÎñ£¬½øÐГֹͣ”¡¢“ÔÝÍ£”¡¢“ÖØÐÂÆô¶¯”µÈ¶¯×÷¡£
Ïà¹ØÎĵµ£º
c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;D ......
½éÉÜ
ͨ³££¬Ñз¢ÈËԱʹÓõÄÊÇT-SQLÀ´´´½¨SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ ¶øÏÖÔÚµÄSQL Server 2005ÒÑÍêÈ«Ö§³Ö.NETͨÓÃÓïÑÔÔËÐÐʱ£¨CLR£©ÁË¡£ Õâ¾ÍÒâζ×Å£¬ÄúÄܹ»Ê¹ÓÃ.NETµÄÓïÑÔ£¬ÈçC#¡¢VB.NETÖ®ÀàµÄÀ´Ñз¢SQL ServerµÄ´æ´¢¹ý³Ì¡¢º¯ÊýºÍ´¥·¢Æ÷¡£ SQL Server ºÍ CLR µÄ¼¯³É¸øÎÒÃÇ´øÀ´ÁËn¶àºÃ´¦£¬Èçʵʱ±àÒë¡¢ÀàÐÍ°²È«¡ ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
......
ÏÂÔØsql2005ÍêÒÔºó½âѹ³öÀ´£¬´ó¼Ò¿ÉÒÔ¿´µ½cs_sql_2005_chs_x86Õâ¸öĿ¼£¬½øÈëÕâ¸öĿ¼ÔËÐÐsetup.exeÎļþ£¬°²×°³ÌÐò¾Í¿ªÊ¼ÔËÐÐÁË¡£
Ê×Ïȵ¯³öÀ´µÄÊÇÈí¼þÐí¿ÉÌõ¿î
¹´ÉÏÎÒ½Ó°®Ðí¿ÉÌõ¿îºÍÌõ¼þ£¬µãÏÂÒ»²½
ÕâÀïÁгöÁËSQL2005ÔËÐл·¾³£¬Ö±½Óµã°²×°
³ÌÐò¿ªÊ¼°²×°SQL2005ÔËÐбØÐèµÄ»·¾³£¬ÅäÖÃ×é¼þ
±ØÐèµÄ×é¼þ°²×°ºÃÁË£¬µãÏÂÒ»²½¼ ......
×¼±¸¹¤×÷£ºÊý¾ÝÇåÏ´¡£¼ì²éÊý¾ÝÀàÐͺͱíÖеÄ×Ö¶ÎÀàÐÍÊÇ·ñÆ¥Å䣻¼ì²é¿ÕÖµÔ¼Êø£»È¥Î޹ؿոñµÈ¡£ÕâЩ¼ì²é¹¤×÷¿ÉÒÔͨ¹ýExcelµÄÊý¾Ýɸѡ¹¦ÄÜ£¬¿´Ò»ÏÂÿ¸ö×Ö¶ÎËùÓеÄÖµ£¬ÔÙÑ¡Öв»ºÏ¹æ·¶µÄ½øÐÐÐ޸ġ£
²½Ö裺
1£©µÇ¼pl/sql developer£¬µÇ¼ʱѡÔñ´ýµ¼Èë±íËùÔÚÊý¾Ý¿â£¬ÔÚ²éѯ´°¿ÚÀïÊäÈësele ......