(ת)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
Ïà¹ØÎĵµ£º
×î½üÕûÀí³öÀ´µÄ.Èç¹û²»ÍêÈ«µÄ»°Ï£Íû´ó¼Ò²¹³ä.
ÔÚaccessÖУ¬×ª»»Îª´óдµÄsqlº¯ÊýÊÇucase£¬ÔÚsqlserverÖУ¬×ª»»Îª´óдµÄº¯ÊýÊÇupper£»ÔÚaccessÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlcase£¬ÔÚsqlserverÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlower£»ÔÚaccessÖУ¬È¡µ±Ç°Ê±¼äµÄº¯ÊýÊÇnow£¬ÁíÍ⻹ÓÐÒ»¸öÈ¡ÈÕÆÚº¯Êýdate£¬ÔÚsqlserverÖУ¬È¡µ±Ç°µÄº¯ÊýÊÇgetdate ......
<%
Dim Conn, Connstr
Dim strServer, strUid, strPwd, strDB
strServer = "HUA-5780C2D1CCF" 'SQLÊý¾Ý¿â·þÎñÆ÷µØÖ·
strUid = "sa" 'Êý¾Ý¿âÓû§Ãû
strPwd = "123456" ......
sp_databases --Áгö·þÎñÆ÷ÉϵÄËùÓÐÊý¾Ý¿â
sp_server_info --Áгö·þÎñÆ÷ÐÅÏ¢£¬Èç×Ö·û¼¯£¬°æ±¾ºÍÅÅÁÐ˳Ðò
sp_stored_procedures--Áгöµ±Ç°»·¾³ÖеÄËùÓд洢¹ý³Ì
sp_tables --Áгöµ±Ç°»·¾³ÖÐËùÓпÉÒÔ²éѯµÄ¶ÔÏó
sp_start_job --Á¢¼´Æô¶¯×Ô¶¯»¯ÈÎÎñ
sp_stop_job --Í£Ö¹ÕýÔÚÖ´ÐеÄ×Ô¶¯»¯ÈÎÎñ
sp_password --Ìí¼Ó»òÐ ......
ÔÚ
SQLServer2005
ÖжÔ
XML
µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË
query(),value(),exist(),modify(),nodes()
µÈº¯Êý¡£
¹ØÓÚ
xml
£¬ÄÑÒÔÀí½âµÄ²»ÊÇ
SQLServer
ÌṩµÄº¯Êý£¬¶øÊǶÔ
xml
±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»Êdzõ̽һ϶øÒÑ¡£
Ïê¼û
SQLServer
Áª»ú°ïÖú£º
Ö÷Ìâ
˵ ......
SQLSERVER--һЩ¾µäÎÊÌâ×ܽá
2007-04-01¡¡01:04:06
´óÖÐС
/**********************************/
--»ñµÃijһÌìËùÔÚÄêµÄµÚÒ»Ìì
declare @a datetime,@b datetime,@sum int,@num int,@res varchar(20)
select @a='1-6-1968'
select @b='2006-4-8'
select @sum=year(@a)
select @res=ltrim(cast(@sum as ......