Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

aspÁ¬sqlserver²âÊÔ´úÂë

<%
Dim Conn, Connstr
Dim strServer, strUid, strPwd, strDB
strServer = "HUA-5780C2D1CCF"        'SQLÊý¾Ý¿â·þÎñÆ÷µØÖ·
strUid = "sa"                'Êý¾Ý¿âÓû§Ãû
strPwd = "123456"  ......

SQLServerÖеÄÑ­»·Åú´¦Àí

  SQLServerÖеÄÑ­»·Åú´¦Àí
GOÃüÁîºóÃæ¼ÓÒ»¸ö³£Á¿¾Í¿ÉÒÔÁË
ÏÂÃæ·½·¨¿ÉÒÔÓÃÀ´¿ìËÙÉú³ÉÒ»ÅúÊý¾Ý
if (object_id ('t' ) is not null ) drop table t
go
create table t (id int identity (1 , 1 ), name varchar (40 ))
go
insert into t (name ) select newid ()
go 10
select * from t
/*
1 &nbs ......

SQLServerÈÎÒâÁÐÖ®¼äµÄ¾ÛºÏ

SQLServerÈÎÒâÁÐÖ®¼äµÄ¾ÛºÏ ÊÕ²Ø
sqlµÄmaxÖ®ÀàµÄ¾ÛºÏº¯ÊýÖ»ÄÜÕë¶ÔͬһÁеÄnÐÐÔËË㣬Èç¹û¶ÔnÁÐÔËË㣬һ°ã¶¼ÓÃcase Óï¾äÀ´Åжϣ¬Èç¹ûÁÐÉÙ»¹±È½ÏÈÝÒ×д£¬ÁжàÁ˾ÍÂé·³ÁË¡£ÕâÀï½éÉÜÒ»¸öͨ¹ýxmlºÏ²¢Áв¢×ªÎªÐм¯ºóÖ±½ÓÓþۺϺ¯ÊýÇóÖµµÄ·½·¨£¬²âÊÔÓÃÀýºÍ´úÂëÈçÏÂ
----------------------------------------------------------- ......

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


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