Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Ë÷ÒýµÄÖØÒªÐÔ!


Ô­ÎÄת×Ô:http://dev.csdn.net/develop/article/71/71778.shtm
 
´ó¶àÊýSQL Server±íÐèÒªË÷ÒýÀ´Ìá¸ßÊý¾ÝµÄ·ÃÎÊËٶȣ¬Èç¹ûûÓÐË÷Òý£¬SQL ServerÒª½øÐбí¸ñɨÃè¶ÁÈ¡±íÖеÄÿһ¸ö¼Ç¼²ÅÄÜÕÒµ½Ë÷ÒªµÄÊý¾Ý¡£Ë÷Òý¿ÉÒÔ·ÖΪ´ØË÷ÒýºÍ·Ç´ØË÷Òý£¬´ØË÷Òýͨ¹ýÖØÅűíÖеÄÊý¾ÝÀ´Ìá¸ßÊý¾ÝµÄ·ÃÎÊËٶȣ¬¶ø·Ç´ØË÷ÒýÔòͨ¹ýά»¤±íÖеÄÊý ......

SQLServerϵͳ´æ´¢¹ý³Ì

sp_databases --Áгö·þÎñÆ÷ÉϵÄËùÓÐÊý¾Ý¿â
sp_server_info --Áгö·þÎñÆ÷ÐÅÏ¢£¬Èç×Ö·û¼¯£¬°æ±¾ºÍÅÅÁÐ˳Ðò
sp_stored_procedures--Áгöµ±Ç°»·¾³ÖеÄËùÓд洢¹ý³Ì
sp_tables --Áгöµ±Ç°»·¾³ÖÐËùÓпÉÒÔ²éѯµÄ¶ÔÏó
sp_start_job --Á¢¼´Æô¶¯×Ô¶¯»¯ÈÎÎñ
sp_stop_job --Í£Ö¹ÕýÔÚÖ´ÐеÄ×Ô¶¯»¯ÈÎÎñ
sp_password --Ìí¼Ó»òÐ ......

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 ......

SQLServerºÍOracle³£Óú¯Êý¶Ô±È

SQLServerºÍOracleÊÇ´ó¼Ò¾­³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......

sqlserver »ù´¡ÖªÊ¶´óÕûÀí

SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_dat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ