[ת]SQL Server 2005 COM+ Ŀ¼ҪÇ󾯸æ
¢Ù¡£Æô¶¯Distributed Transaction Coordinator ·þÎñ
´ò¿ª·þÎñ£¬ÔÚ·þÎñÖÐÕÒµ½Distributed Transaction Coordinator·þÎñ£¬Ñ¡Ôñ“ÊôÐÔ”£»
ÔÚ“µÇ¼”Ñ¡ÏÖУ¬Ñ¡Ôñ“´ËÕÊ»§”£¬ÕÊ»§ÃûÌîд“NT AUTHORITY\NetworkService”£¬ÃÜÂëΪ¿Õ£»
ÔÚµã»÷“È·¶¨”ºóÖØÐÂÆô¶¯·þÎñ¡£
»òÕߣ¬ÔÚÃüÁîÐÐÏÂÔËÐÐ msdtc -uninstall £¬Ð¶ÔØ msdtc ·þÎñ£»
ÔÙÔËÐÐ msdtc -install £¬°²×° msdtc ·þÎñ¡£
MSTDC·þÎñ³É¹¦Æô¶¯£¬×é¼þ·þÎñÖГCOM+Ó¦ÓóÌÐò”¿ÉÒÔ·ÃÎÊ¡£
Èç¹ûÄãÒ²Óöµ½ÁËDistributed Transaction Coordinator ·þÎñ²»ÄÜÆô¶¯
´íÎó:Distributed Transaction Coordinator ·þÎñÒò 3221229584 (0xC0001010)
·þÎñÐÔ´íÎó¶øÍ£Ö¹¡£ÕâÑù½â¾ö£º
µã¿ªÊ¼→ÔËÐÐ→ÊäÈëÃüÁî"msdtc -resetlog",ÔËÐиÃÃüÁî¼´¿É£¬È»ºóÔÙÊÔ×Å¿ªÆôDistributed Transaction Coordinator ·þÎñ¡£
¢Ú °´ÕÕÏÂÁйý³ÌÖØа²×° COM+
°²×°×é¼þ·þÎñ¹ÜÀíµ¥Ôª
ÔÚ Windows ×ÀÃæÉÏ£¬µ¥»÷“¿ªÊ¼”£¬È»ºóµ¥»÷“ÔËÐД¡£
ÔÚ“´ò¿ª”¿òÖУ¬¼üÈë MMC£¬È»ºóµ¥»÷“È·¶¨”¡£
ÔÚ“¿ØÖÆ̨”´°¿ÚÖУ¬µ¥»÷²Ëµ¥À¸ÉϵēÎļþ”£¬È»ºóµ¥»÷“Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª”¡£
ÔÚ“Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª”´°¿Ú£¬µ¥»÷“Ìí¼Ó”¡£
ÔÚ“Ìí¼Ó¶ÀÁ¢¹ÜÀíµ¥Ôª”´°¿Ú£¬´Ó¹ÜÀíµ¥ÔªÁбíÖÐÑ¡Ôñ“×é¼þ·þÎñ”£¬È»ºóµ¥»÷“Ìí¼Ó”¡£
µ¥»÷“¹Ø±Õ”ÒԹرՓÌí¼Ó¶ÀÁ¢¹ÜÀíµ¥Ôª”´°¿Ú£¬È»ºóµ¥»÷“È·¶¨”ÒԹرՓÌí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª”´°¿Ú¡£
ÔÚ“¿ØÖÆ
Ïà¹ØÎĵµ£º
¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL Server±íµ¼ÈëÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔÔÚT-SQL(Transact-SQL£¬Î¢Èí¶ÔSQLµÄÀ©Õ¹)ÖÐÓÃOPENROWSETº¯Êý¸øÊý¾ÝÔ´´«ÈëÒ»¸öÁ¬½Ó´®ºÍ²éѯÀ´ÌáÈ¡ÐèÒªµÄÊý¾Ý¡£
¡¡¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL ......
¡¡ÔÚSQL ServerÊý¾Ý¿âÖУ¬µ±ÄãÏëʹÓÃÒ»¸öÊý¾Ý£¬¶øÕâ¸öÊý¾Ý²»±£´æÔÚ±íÖУ¬¼ÆËãÁкÜÓÐÓá£ÀýÈ磬ÄãÓÐÒ»ÕÅ±í£¬Ëü°üÀ¨ÁÐdollar amounts, wholesale pricesºÍretail prices¡£Äã¿Ï¶¨²»ÏëÔÚÿ´Î²éѯ±íʱÀ´¼ÆËãÄÇÁ½ÁÐÖ®¼äµÄ²îÖµ£¬ÄãÏ£Íû½«ÆäÖµ±£´æÔÚµÚÈýÁÐÖУ¬ÈÃÆä×Ô¶¯¼ÆËãÇ°Á½ÁÐÖ®¼äµÄ²îÖµ¡£¶ø´ËÁоÍÊǼÆËãÁС£
¡¡¡¡ÔÚSQL ServerÖ ......
1¡¢×÷ÓÃ
ɾ³ýÖ¸¶¨³¤¶ÈµÄ×Ö·û£¬²¢ÔÚÖ¸¶¨µÄÆðµã´¦²åÈëÁíÒ»×é×Ö·û¡£
2¡¢Óï·¨
STUFF ( character_expression , start , length ,character_expression )
3¡¢Ê¾Àý
ÒÔÏÂʾÀýÔÚµÚÒ»¸ö×Ö·û´® abcdÖÐɾ³ý´ÓµÚ 2 ¸öλÖã¨×Ö·û b£©¿ªÊ¼µÄÈý¸ö×Ö·û£¬È ......
SELECT A,B=stuff((select ' ' + '×Ö¶ÎC£º' + C + ',×Ö¶ÎD£º' + D) + ';' from tbl WHERE (key= 'Ìõ¼þ') for xml path('')) , 1 , 1 ,'')
from tbl
WHERE (key= 'Ìõ¼þ')
group by key
ÀýÈ磺һ¸ö±íÖÐkeyΪAAµÄ¼Ç¼ÓÐ2Ìõ£¬µÚÒ»ÌõÖÐ×Ö¶ÎCµÄֵΪCC£¬×Ö¶ÎDµÄֵΪDD£¬µÚ¶þÌõÖÐ×Ö¶ÎCµÄֵΪCCC£¬×Ö¶ÎDµÄֵΪ ......
µÚÒ»²¿·Ö »ù±¾¸ÅÄî
Ò»¡¢ ......