(ת)SqlserverºÏ²¢¸´ÖƵÄwebͬ²½Ïê½â(ת΢ÈíÈýƪ)1
¸ÅÊö£º
ÅäÖà Web ͬ²½
url: http://technet.microsoft.com/zh-cn/library/ms151810(SQL.90).aspx
ÈôÒª¶Ô¸´ÖÆʹÓà Web ͬ²½£¬ÇëÖ´ÐÐÏÂÁв½Ö裺
ÅäÖ÷¢²¼£¬ÒÔÔÊÐíʹÓà Web ͬ²½¡£
ÅäÖÃÔËÐÐ Microsoft Internet ÐÅÏ¢·þÎñ (IIS) µÄ¼ÆËã»úÒÔͬ²½¶©ÔÄ¡£Ö§³Ö IIS 5.0 ºÍ 6.0 °æ¡£
ÅäÖÃÒ»¸ö»ò¶à¸ö¶©ÔÄÒÔʹÓà Web ͬ²½¡£
ÔÚÅäÖà Web ͬ²½Ç°£¬½¨ÒéÄúÏÈÔĶÁ±¾Ö÷ÌâºóÃæµÄ“Web ͬ²½µÄ×î¼Ñ°²È«ÅäÖÔ¡£ÓÐ¹Ø Web ͬ²½°²È«ÐÔµÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ Web ͬ²½µÄ°²È«Ìåϵ½á¹¹¡£
ÅäÖ÷¢²¼
ÈôҪʹÓà Web ͬ²½£¬ÐèÒªÏÈ´´½¨Ò»¸ö·¢²¼£¨¾ÍÏñΪ±ê×¼ºÏ²¢ÍØÆË´´½¨·¢²¼Ò»Ñù£©¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ·¢²¼Êý¾ÝºÍÊý¾Ý¿â¶ÔÏó¡£Èç¹ûÄúÊ×´ÎʹÓ÷¢²¼·þÎñÆ÷£¬»¹±ØÐëÅäÖ÷ַ¢·þÎñÆ÷ºÍ¿ìÕÕ¹²Ïí¡£Ã¿Ì¨¶©ÔÄ·þÎñÆ÷Éϵĺϲ¢´úÀí¶¼±ØÐë¶Ô¿ìÕÕ¹²Ïí¾ßÓжÁȡȨÏÞ¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ÅäÖ÷ַ¢ºÍ ±£»¤¿ìÕÕÎļþ¼ÐµÄ°²È«¡£
´´½¨·¢²¼ºó£¬ÆôÓÃÔÊÐíͨ¹ý SQL Server Management Studio¡¢Transact-SQL »ò¸´ÖƹÜÀí¶ÔÏó (RMO) ½øÐÐ Web ͬ²½µÄÑ¡Ïî¡£
ÅäÖ÷¢²¼ÒÔÔÊÐíʹÓà Web ͬ²½
SQL Server Management Studio: ÈçºÎÅäÖ÷¢²¼ÒÔÔÊÐíʹÓà Web ͬ²½ (SQL Server Management Studio)
¸´ÖÆ Transact-SQL ±à³Ì£º How to: Configure a Publication to Allow for Web Synchronization (Replication Transact-SQL Programming)
RMO£º How to: Configure a Publication to Allow for Web Synchronization (RMO Programming)
ÅäÖÃÕýÔÚÔËÐÐ IIS µÄ¼ÆËã»ú
Web ͬ²½ÒªÇó°²×°²¢ÅäÖà IIS¡£ÆôÓ÷¢²¼ºó£¬ÅäÖÃÕýÔÚÔËÐÐ IIS µÄ¼ÆËã»úÒÔÖ§³Ö Web ͬ²½¡£ÓÐ¹Ø IIS °²×°µÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ IIS Îĵµ¡£
ÅäÖà IIS ÒÔʵÏÖ Web ͬ²½
SQL Server Management Studio: ÈçºÎΪ Web ͬ²½ÅäÖà IIS
ÅäÖö©ÔÄ
ÆôÓ÷¢²¼²¢ÅäÖà IIS ºó£¬´´½¨ÇëÇó¶©ÔIJ¢Ö¸¶¨¸ÃÇëÇó¶©ÔÄӦͨ¹ýʹÓà IIS ½øÐÐͬ²½¡££¨½öÇëÇó¶©ÔÄÖ§³Ö Web ͬ²½¡££©
ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½
SQL Server Management Studio: ÈçºÎÅäÖö©ÔÄÒÔʹÓà Web ͬ²½ (SQL Server Management Studio)
¸´ÖÆ Transact-SQL ±à³Ì£º How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL Programming)
RMO£º How to: Configure a Subscription to Use Web Synchronization (RMO Programming)
Web ͬ²½µÄ×î¼Ñ°²È«ÅäÖÃ
ÔÚ Web ͬ²½ÖУ¬ÓкܶàÓ밲ȫÏà¹ØµÄÉèÖÿɹ©Ñ¡Ôñ¡£½¨ÒéʹÓÃÒÔÏ·½·¨£º
SQ
Ïà¹ØÎĵµ£º
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 18C1C418-9029-4599-8D5E-616354A113C8
2 A0FE1177-09D8-4C56-9FB5-C2FA ......
HOLDLOCK ½«¹²ÏíËø±£Áôµ½ÊÂÎñÍê³É£¬¶ø²»ÊÇÔÚÏàÓ¦µÄ±í¡¢ÐлòÊý¾ÝÒ³²»ÔÙÐèҪʱ¾ÍÁ¢¼´ÊÍ·ÅËø¡£HOLDLOCK µÈͬÓÚ SERIALIZABLE¡£
NOLOCK ²»Òª·¢³ö¹²ÏíËø£¬²¢ÇÒ²»ÒªÌṩÅÅËüËø¡£µ±´ËÑ¡ÏîÉúЧʱ£¬¿ÉÄÜ»á¶ÁȡδÌá½»µÄÊÂÎñ»òÒ»×éÔÚ¶ÁÈ¡Öмä»Ø¹öµÄÒ³Ãæ¡£ÓпÉÄÜ·¢ÉúÔà¶Á¡£½öÓ¦ÓÃÓÚ SELECT Óï¾ä¡£
PAGLOCK ÔÚͨ³£Ê¹Óõ¥¸ö±íËøµ ......
ÔÚÓÃAsp.net¶Ô±¸·ÝµÄÊý¾Ý¿âÎļþ½øÐл¹ÔµÄʱºò£¬ÓÐʱºò»á³öÏÖÏÂÃæµÄ´íÎóÒì³££º
[ÒòΪÊý¾Ý¿âÕýÔÚʹÓã¬ËùÒÔδÄÜ»ñµÃ¶ÔÊý¾Ý¿âµÄÅÅËü·ÃÎÊȨ¡£ RESTORE DATABASE ²Ù×÷Òì³£ÖÕÖ¹¡£Òѽ«Êý¾Ý¿âÉÏÏÂÎĸÄΪ 'master'¡£]
Õâ¸öʱºò£¬×ÔÓɵȴýÆäËû½ø³ÌÊͷŶÔӦȨÏ޺󣬲ſɻ¹Ô³É¹¦£¡ÓÐûÓнâ¾ö°ì·¨ÄØ£¿ÎÒ²ÎÕÕ¡¾Java¡¿¶ÔÕâ¸öÎÊÌâµÄ½â¾ö ......
ÁÙ½üÄêÖÕ£¬ÔÚ¹¤×÷Ö®Óà¶Ô¹¤×÷ºÍѧϰÖÐÓöµ½µÄÎÊÌâÒÔ¼°³£ÓõÄһЩ֪ʶµã×öÁËЩÕûÀí£¬ÒÔ±¸ºóÓᣱ¾ÎÄÉæ¼°µÄÄÚÈÝΪÊý¾Ý¿â,ËãÊǶԿª·¢×ܽá(1)---Êý¾Ý¿âÒ»ÎĵIJ¹³ä¡£
1 ¶ÔÓÚÖ÷¼üÉèÖÃÁËIdentityµÄ±í£¬ÔÚɾ³ý±íÖÐÊý¾ÝºóÔÙÍù±íÖвåÈëÊý¾Ý£¬IdentityÁв»ÊÇ´Ó1ÆðʼÁË£¬Èç¹ûÏëɾ³ýÊý¾ÝºóIndentityÁÐÈÔ´Ó1Æðʼ£¬¿ÉÒÔÓÃÏÂÃæ´úÂëÀ´É¾³ýÊý¾Ý ......
--ÿ¸öÔµĵÚÒ»Ìì
select dateadd(dd,-datepart(dd,getdate())+1,getdate())
--µÚ¸öÔµÄ×îºóÒ»Ìì
select dateadd(dd,-datepart(dd,getdate()),dateadd(mm,1,getdate()))
--±¾ÔµÄÌìÊý
select datediff(dd,getdate(),dateadd(mm,1,getdate()))
......