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

SQL Server 2005——Ô¶³ÌÁ¬½ÓÅäÖÃ

×î½ü×öÏîÄ¿£¬ÐèÒªÔ¶³Ì·ÃÎÊÊý¾Ý¿â£¬×Ô¼ºÔÚ²éÁËЩ×ÊÁÏ£¬×ܽáÁËһϣ¬Ï£Íû¶Ô´ó¼ÒÓаïÖú£º
×÷Õߣºshinehoo
Ò»¡¢ÅäÖÃSQL Server 2005
1£©°²×°SQL Server 2005¿ª·¢°æ£»
2£©¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->SQL
Server 2005ÍâΧӦÓÃÅäÖÃÆ÷£¬ÔÚ´ò¿ªµÄ½çÃæµ¥»÷“·þÎñµÄÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”£¬ÔÚ´ò¿ªµÄ½çÃæÖÐÕÒµ½Database Engine£¬µ¥»÷“·þÎñ”£¬ÔÚÓÒ²à²é¿´ÊÇ·ñÒÑÆô¶¯£¬Èç¹ûûÓÐÆô¶¯¿Éµ¥»÷“Æô¶¯”£¬²¢È·±£"Æô¶¯ÀàÐÍ"Ϊ×Ô¶¯£¬²»ÒªÎªÊÖ¶¯£¬·ñÔòÏ´οª»úʱÓÖÒªÊÖ¶¯Æô¶¯£»È»ºóµ¥»÷“Ô¶³ÌÁ¬½Ó”£¬Ñ¡Ôñ“ͬʱʹÓÃTCP/IPºÍnamed pipes”£»
3£©¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server
Configuration Manager£¬µã»÷“SQL Server 2005·þÎñ”£¬°ÑËùÓГÆô¶¯Ä£Ê½”¸ÄΪ“×Ô¶¯”£»È»ºó£¬µã»÷“SQL
Server 2005ÍøÂçÅäÖÔÖеēMSSQLSERFERµÄЭÒ锣¬°ÑÇ°Èý¸öÉèÖÃΪ“ÒÑÆôÓÔ£¬ºóÒ»¸ö“VIA”ÉèÖÃΪ“ÒѽûÓÔ£»
4£©¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005-> SQL
Server Management Studio£¬µÇ¼½øÈ¥ÓÒ¼üµã»÷“SERVER424”Êý¾Ý¿â£¬Ñ¡Ôñ“ÊôÐÔ”£¬È»ºóÑ¡Ôñ“Á¬½Ó”£¬¹´ÉÏ“ÔÊÐíÔ¶³ÌÁ¬½Óµ½´Ë·þÎñÆ÷”£¬²¢°Ñ“Ô¶³Ì²éѯ³¬Ê±Öµ”ÉèÖÃΪ0£¨ÎÞ³¬Ê±£©£»ÁíÍ⣬ÔÚ“SERVER424”Êý¾Ý¿â“ÊôÐÔ”ÀïµÄ“°²È«ÐÔ”ÖÐÑ¡Ôñ“SQL ServerºÍWindowsÉí·ÝÑé֤ģʽ”£»ÔÚ¸ùĿ¼Ïµē°²È«ÐÔ”ÀïµÄ“µÇ¼Ãû”£¬Ñ¡ÔñÄúµÄÓû§Ãû“ÊôÐÔ”ÖÐÉèÖÃÃÜÂ루Զ³ÌÁ¬½Ó±ØÐëÒªÉèÖÃÃÜÂë²ÅÐУ©
5£©ËùÓÐÉèÖÃÍê³Éºó£¬ÔÚ¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server Configuration ManagerÖУ¬ÖØÐÂÆô¶¯“SQL Server
2005·þÎñ- >SQL
SERVER(MSSQLSERVER)”¡£
6£©´ò¿ªSQL Server 2005 µÄ1433¶Ë¿Ú
ÅäÖù¤¾ß->Sql Server Configuration
Manager->MSSQLSERVERµÄЭÒ飬¿´¿´TCP/IPЭÒéÊÇ·ñÆô¶¯£¬Èç¹ûÆô¶¯£¬ÓÒ¼ü²Ëµ¥µã“ÊôÐÔ”£¬ÔÚ·ÖÒ³²Ëµ¥ÖÐÑ¡“IPµØÖ·”£¬°Ñ“IP1”ºÍ“IP2”ÖГTCP¶Ë¿Ú”Ϊ1433£¬“ÒÑÆôÓÔ¸ÄΪ“ÊÇ”£»
ÅäÖù¤¾ß->Sql Server C


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......

SQl Êý¾Ý¿âÏà¹Ø²Ù×÷

1£º
Sql server 2005ÈÕÖ¾ÎļþÌ«´ó,ʹÆä¼õСµÄ·½·¨
ÔËÐÐÏÂÃæµÄÈýÐÐ PMDataCenter  ΪÊý¾Ý¿âÃû:
backup log PMDataCenter with NO_LOG
backup log PMDataCenter with TRUNCATE_ONLY
DBCC SHRINKDATABASE(PMDataCenter) ......

SQL Union ÓëUnion AllÏê½â

1.Union
UNION Ö¸ÁîµÄÄ¿µÄÊǽ«Á½¸ö SQL Óï¾äµÄ½á¹ûºÏ²¢ÆðÀ´¡£´ÓÕâ¸ö½Ç¶ÈÀ´¿´£¬ UNION ¸ú JOIN ÓÐЩÐíÀàËÆ£¬ÒòΪÕâÁ½¸öÖ¸Á¿ÉÒÔÓɶà¸ö±í¸ñÖÐߢȡ×ÊÁÏ¡£ UNION µÄÒ»¸öÏÞÖÆÊÇÁ½¸ö SQL Óï¾äËù²úÉúµÄÀ¸Î»ÐèÒªÊÇͬÑùµÄ×ÊÁÏÖÖÀà¡£ÁíÍ⣬µ±ÎÒÃÇÓà UNIONÕâ¸öÖ¸Áîʱ£¬ÎÒÃÇÖ»»á¿´µ½²»Í¬µÄ×ÊÁÏÖµ (ÀàËÆ SELECT DISTINCT)¡£
UNION µ ......

Linq²éѯ DataSet ÄÜ·ñºÍSQL ¼¶Áª£¿

        ×î½ü×öÏîÄ¿µÄʱºò£¬Óöµ½ÁËÒ»¸öÎÊÌâ¡£ÎÒÖ÷ÒªÊÇ×öÒ»¸öWeb Services¸ø±ðÈËÓõġ£±ðÈË´«Ò»¸öÓû§IDºÅ¹ýÀ´£¬È»ºóÎÒ½«Õâ¸öÓû§µÄËùÓкÃÓѵÄÏÂÔؼǼ°ü×°³ÉÒ»¸öDataSet·µ»ØÈ¥¡£ ¶ø¸ù¾ÝÓû§IDºÅ»ñÈ¡¸ÃÓû§µÄËùÓкÃÓÑÐÅÏ¢£¬ÔòÊÇͨ¹ýÁíÒ»¸öWeb ServicesµÃµ½µÄ£¬ÕâÀïΪFriendDS¡£
  ......

SQL ServerÖд洢¹ý³Ì±ÈÖ±½ÓÔËÐÐSQLÓï¾äÂýµÄÔ­Òò

ÔںܶàµÄ×ÊÁÏÖж¼ÃèÊö˵SQLSERVERµÄ´æ´¢¹ý³Ì½ÏÆÕͨµÄSQLÓï¾äÓÐÒÔÏÂÓŵ㣺
1.       ´æ´¢¹ý³ÌÖ»ÔÚ´´Ôìʱ½øÐбàÒë¼´¿É£¬ÒÔºóÿ´ÎÖ´Ðд洢¹ý³Ì¶¼²»ÐèÔÙÖØбàÒ룬¶øÎÒÃÇͨ³£Ê¹ÓõÄSQLÓï¾äÿִÐÐÒ»´Î¾Í±àÒëÒ»´Î,ËùÒÔʹÓô洢¹ý³Ì¿ÉÌá¸ßÊý¾Ý¿âÖ´ÐÐËٶȡ£
2.     &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ