¹ØÓÚSQL Server·þÎñ¹ÜÀíÆ÷µÄÎÊÌâ
ÎÊÌâ: һ̨·þÎñÆ÷ÉÏÔËÐÐÁËSQL Server,SQL Server Agent,Distributed Transaction,CoordinatorÕâÈý¸ö·þÎñ£¬ÇëÎÊÕą̂·þÎñÆ÷ÊÇһ̨ʲôÑùµÄ·þÎñÆ÷£¿ÕâÈý¸ö·þÎñ¾ßÌåÓÐʲô×÷Óã¿
ÕâÊÇһ̨Êý¾Ý¿â·þÎñÆ÷.
SQL Server ÕâÊÇÖ÷Êý¾Ý¿â·þÎñ£¬¶øÇÒÐγÉÁËSQL ServerµÄÖ§Öù¡£ËüÓÃÓÚ´æ´¢ºÍÌáÈ¡Êý¾Ý¡£
SQL Server Agent Ò²½ÐSQL Server´úÀí£¬ÒÔÇ°³ÆΪSQLÖ´ÐÐÕߣ¬ÕâÊÇSQL ServerµÄÈÎÎñÈÕ³Ì±í¡£ÕâÖÖ·þÎñÖ÷ÒªÊÇÓÃÓÚÔÚÉ趨µÄʱ¼ä±¸·Ý¡¢¸´ÖÆÊý¾Ý£¬ÒÔ¼°ÔÚ×Ô¶¯Ö´Ðе÷¶È±íÉÏÉèÖõÄÆäËûÏîÄ¿¡£Æô¶¯Õâ¸ö·þÎñºó£¬É趨ºÃÔÚʲôʱºò×öʲôÊ£¬Õâ¸ö·þÎñ»áÈÃËü×Ô¶¯ÔËÐУ¬²»ÐèÒªÈ˹¤¸ÉÔ¤(¸Õ²ÅÍüÁËÆô¶¯Õâ¸ö·þÎñ,¶ø½øÐб¸·Ý,¾ÍÓе¯³ö´íÎó)¡£
Distributed Transaction,CoordinatorMSDTC£¨·Ö²¼Ê½½»Ò×е÷Æ÷£©µÄ½ø³ÌÃûÊÇMsdtc.exe£¬WinXP Home/ProĬÈÏ°²×°µÄÆô¶¯ÀàÐÍÊÇÊÖ¶¯£¬ÒÀÀµRemote Procedure CallºÍSecurity Accounts Manager·þÎñ¡£MSDTCÖ÷ÒªÓÃÀ´´¦Àí·Ö²¼Ê½½»Ò×£¬Ëùν·Ö²¼Ê½½»Ò×£¬¾ÍÊÇ¿çÔ½Á½¸ö»ò¶à¸öÊý¾Ý¿âµÄµ¥Ò»SQL ServerÄÚ²¿µÄ½»Òס£Í¬Ò»Êý¾Ý¿âÄÚ²»Í¬Êý¾Ý±í¼äµÄ½»Ò×£¬Ôò²»ÄܳÆ×÷·Ö²¼Ê½½»Òס£ÏÔÈ»¶ÔÓÚÐèҪͬʱ´¦Àí¶à¸öÊý¾Ý¿â»òÎļþϵͳµÄÓû§À´Ëµ£¬Õâ¸ö·þÎñÒâÒåÖش󣬵«ËüÒ²ÊÇͨ³£ÒâÒåÉÏÒ»°ãÓû§²»»áʹÓõ½µÄ·þÎñ£¬Í¨³£À´Ä¬ÈÏÊÖ¶¯Æô¶¯¾ÍºÃÁË£¬ÆäʵÕâ¸ö·þÎñÒ²ÈÝÒ×Êܵ½Ô¶³Ì¾Ü¾ø·þÎñ¹¥»÷£¬½ûÓÃËüҲûÓÐÎÊÌ⣬¶øÇÒ¸ü°²È«¡£
С³£Ê¶£ºËùÓпª»úÆô¶¯µÄ·þÎñ»òÕß³ÌÐò£¬¶¼ÄÜÔÚmsconfigÀïÃæ¿´µ½£¬ÔËÐÐÓë·ñ¿ÉÒÔÔÚservices.mscÀï¿´µ½¡£
Ïà¹ØÎĵµ£º
SQL Server ·ÖÒ³
½¨Á¢±í£º
CREATE TABLE [TestTable] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[FirstName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[LastName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note] [nvarchar ......
¡¡×î½üÔÚÕÛÌÚ PHP + MYSQL
µÄ±à³Ì¡£Á˽âÁËһЩ PHP SQL ×¢Èë¹¥»÷
µÄ֪ʶ£¬ÓÚÊÇдÁËÕâƪÎÄÕ¡¡http://www.xiaohui.com/weekly/20070314.htm£¬×ܽáһϾÑé¡£ÔÚÎÒ¿´À´£¬Òý·¢ SQL ×¢Èë¹¥»÷
µÄÖ÷ÒªÔÒò£¬ÊÇÒòΪÒÔÏÂÁ½µãÔÒò£º
¡¡¡¡1. php ÅäÖÃÎļþ php.ini ÖÐµÄ magic_quotes_gpc
Ñ¡ÏîûÓдò¿ª£¬±»ÖÃΪ off
¡¡¡¡2. ¿ª·¢ ......
¸ÅÊö
Microsoft SQL Server 2008 ÈÃÄúÄܹ»Í¨¹ýÖ±¹ÛµÄÊý¾ÝÍÚ¾òµÄÔ¤²âÐÔ·ÖÎöÀ´×ö³öÃ÷ÖǺÏÀíµÄ¾ö²ß£¬ÎÞ·ìµØÕûºÏ Microsoft ÉÌÒµÖÇÄÜƽ̨²¢¿ÉÀ©Õ¹ÖÁÉÌÒµÓ¦ÓóÌÐò¡£
ÖØ´óµÄй¦ÄÜ
ͬʱÀûÓôíÎóºÍ¾«È·¶ÈµÄͳ¼Æ·ÖÊýÀ´²âÊÔ¶à¸öÊý¾ÝÍÚ¾òÄ£ÐÍ£¬²¢ÀûÓý»²æÑéÖ¤À´È·ÈÏÆäÎȶ¨ÐÔ
ÔÚµ¥Ò»½á¹¹Öн¨Á¢¶à¸ö²»¼æÈݵÄÍÚ¾òÄ£ÐÍ¡¢ÔÚɸѡ¹ýµÄÊ ......
select pcode from (
select h.k,h.d,h.m,h.u,l.areacode,
l.areacode||substr(h.u,4,length(h.u))||h.k pcode
from(
&nb ......
±¾ÎÄÀ´×Ô£ºhttp://niunan.javaeye.com/blog/264197
±È½ÏÍòÄܵķÖÒ³£º
select top ÿҳÏÔʾµÄ¼Ç¼Êý * from topic where id not in
(select top £¨µ±Ç°µÄÒ³Êý-1£©×ÿҳÏÔʾµÄ¼Ç¼Êý id from topic order by id& ......