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

SqlserverºÏ²¢¸´ÖƵÄwebͬ²½Ïê½â(ת΢ÈíÈýƪ)3


ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
±¾Ö÷ÌâµÄ¹ý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚÈý¸ö²½Öè¡£Ó¦ÔÚÆôÓ÷¢²¼²¢ÅäÖà Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÈçºÎΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½ (SQL Server Management Studio)¡£ÔÚÍê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çëͬ²½´´½¨µÄ¶©ÔÄ¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ÈçºÎͬ²½ÇëÇó¶©ÔÄ (SQL Server Management Studio)¡£
ÈôÒªÅäÖÃÇëÇó¶©ÔÄÒÔʹÓà Web ͬ²½£¬ÇëʹÓÃн¨¶©ÔÄÏòµ¼£¬¾ßÌå¹ý³ÌÈçÏÂËùÊö¡£
×¢Ò⣺
ÈôÒªÔËÐÐн¨¶©ÔÄÏòµ¼£¬±ØÐ뽨Á¢´Ó¶©ÔÄ·þÎñÆ÷µ½·¢²¼·þÎñÆ÷µÄ SQL Server Á¬½Ó¡£Èç¹û¶©ÔÄ·þÎñÆ÷Ö»ÄÜͨ¹ý HTTP ½øÐÐÁ¬½Ó£¬ÇëʹÓô洢¹ý³ÌÀ´ÅäÖö©ÔÄ¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL Programming)¡£
 ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½
ÔÚн¨¶©ÔÄÏòµ¼µÄ“ºÏ²¢´úÀíλÖÔҳÖУ¬Ñ¡ÖГÔÚÆ䶩ÔÄ·þÎñÆ÷ÖÐÔËÐÐÿ¸ö´úÀí(ÇëÇó¶©ÔÄ)”¡£ÓйØÈçºÎʹÓôËÏòµ¼µÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ÈçºÎ´´½¨ÇëÇó¶©ÔÄ (SQL Server Management Studio)¡£
ÔÚ“Web ͬ²½”Ò³ÖУ¬ÎªÃ¿¸öӦʹÓà Web ͬ²½·½·¨µÄ¶©ÔÄ·þÎñÆ÷Ñ¡Ôñ“ʹÓà Web ͬ²½”¡£
ÔÚ“Web ·þÎñÆ÷ÐÅÏ¢”Ò³ÖУº
½ÓÊÜΪ Web ͬ²½ÅäÖ÷¢²¼Ê±Ö¸¶¨µÄĬÈÏ Web µØÖ·£¬»òΪÆäËû IIS ʵÀýÊäÈëÍêÈ«ÏÞ¶¨µÄ URL¡£
Ñ¡ÔñÁ¬½Óµ½ IIS ʱҪʹÓõÄÉí·ÝÑéÖ¤ÀàÐÍ¡£Ö»ÄÜʹÓÃͨ¹ýÅäÖà Web ͬ²½Ïòµ¼»ò IIS ¹ÜÀíÆ÷Ϊ IIS ÆôÓõÄÉí·ÝÑéÖ¤ÀàÐÍ¡£
ÎÒÃǽ¨ÒéÄúʹÓôøÓа²È«Ì×½Ó×Ö²ã (SSL) µÄ»ù±¾Éí·ÝÑéÖ¤¡£ÎÞÂÛʹÓúÎÖÖÀàÐ͵ÄÉí·ÝÑéÖ¤£¬¶¼ÐèÒª SSL¡£Èç¹ûÖ¸¶¨»ù±¾Éí·ÝÑéÖ¤£¬Ôò½¨ÒéΪ IIS Á¬½ÓÖ¸¶¨ÓëÔÚ´ËÏòµ¼ÖÐΪºÏ²¢´úÀíËùÖ¸¶¨ÕÊ»§ÏàͬµÄÕÊ»§¡£
×¢Ò⣺
»ù±¾Éí·ÝÑéÖ¤Êǽ«Æ¾¾Ý´«µÝ¸ø IIS ʱËù²ÉÓõķ½·¨¡£ÔÚʹÓûù±¾Éí·ÝÑé֤ʱ£¬ÈÔÈ»¿ÉÒÔΪÓë IIS ½¨Á¢µÄÁ¬½ÓÖ¸¶¨ Windows ÓòÕÊ»§¡£ÓÐ¹Ø Web ͬ²½µÄ×î¼Ñ·½·¨µÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½ÖеēWeb ͬ²½µÄ×î¼Ñ°²È«ÅäÖÔ²¿·Ö¡£
Íê³ÉÏòµ¼¡£


Ïà¹ØÎĵµ£º

¡¾¸Äб¹éÕý¡¿ sqlserver sql ·ÖÒ³Óï¾ä

      ÔÚGoogleÉÏʹÓÓsql ·ÖÒ³”¹Ø¼ü×Ö½øÐÐËÑË÷£¬¼¸ºõËùÓеĴ𰸶¼ÊÇÄÇÈýÌõ¡£Æä¶þЧÂÊ×î¸ß£¬ÆäÈýʹÓÃÓα꣬ЧÂÊ×î²î¡£
      ÏÂÃæÊÇÄÇÈýÖÖ·½·¨ £¨²åÈë´úÂëûÓÐsqlÑ¡Ï
·½·¨1£º
ÊÊÓÃÓÚ SQL Server 2000/2005
SELECT TOP Ò³´óС *
from table1
WHERE ......

c#ÖиßЧµÄexcelµ¼ÈësqlserverµÄ·½·¨

±¾ÎÄÀ´×ÔCSDN²©¿Í£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ­»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´úÂëµ¼ÈëÒ»¸ö6 ......

ASP.NET»Ö¸´SqlServerÊý¾Ý¿â»¹Ô­Ê§°Ü

ÔÚÓÃAsp.net¶Ô±¸·ÝµÄÊý¾Ý¿âÎļþ½øÐл¹Ô­µÄʱºò£¬ÓÐʱºò»á³öÏÖÏÂÃæµÄ´íÎóÒì³££º
[ÒòΪÊý¾Ý¿âÕýÔÚʹÓã¬ËùÒÔδÄÜ»ñµÃ¶ÔÊý¾Ý¿âµÄÅÅËü·ÃÎÊȨ¡£ RESTORE DATABASE ²Ù×÷Òì³£ÖÕÖ¹¡£Òѽ«Êý¾Ý¿âÉÏÏÂÎĸÄΪ 'master'¡£]
Õâ¸öʱºò£¬×ÔÓɵȴýÆäËû½ø³ÌÊͷŶÔӦȨÏ޺󣬲ſɻ¹Ô­³É¹¦£¡ÓÐûÓнâ¾ö°ì·¨ÄØ£¿ÎÒ²ÎÕÕ¡¾Java¡¿¶ÔÕâ¸öÎÊÌâµÄ½â¾ö ......

18¾ä»°ÈëÃÅSQLServer XML

18¾ä»°ÈëÃÅSQLServer XML ÊÕ²Ø
/*
sql xml ÈëÃÅ:
    --by jinjazz
    --http://blog.csdn.net/jinjazz
   
    1¡¢xml:        ÄÜÈÏʶԪËØ¡¢ÊôÐÔºÍÖµ
   
    2¡¢xpath: ......

£¨×ª£©SqlserverºÏ²¢¸´ÖƵÄwebͬ²½Ïê½â(ת΢ÈíÈýƪ)2


ÈçºÎΪ Web ͬ²½ÅäÖà IIS
¸üÐÂÈÕÆÚ£º 2006 Äê 12 Ô 12 ÈÕ
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Öè£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ