Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

[ת]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£¬È»ºóµ¥»÷“È·¶¨”¡£
        ÔÚ“¿ØÖÆ̨”´°¿ÚÖУ¬µ¥»÷²Ëµ¥À¸ÉϵēÎļþ”£¬È»ºóµ¥»÷“Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª”¡£
        ÔÚ“Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª”´°¿Ú£¬µ¥»÷“Ìí¼Ó”¡£
        ÔÚ“Ìí¼Ó¶ÀÁ¢¹ÜÀíµ¥Ôª”´°¿Ú£¬´Ó¹ÜÀíµ¥ÔªÁбíÖÐÑ¡Ôñ“×é¼þ·þÎñ”£¬È»ºóµ¥»÷“Ìí¼Ó”¡£
        µ¥»÷“¹Ø±Õ”ÒԹرՓÌí¼Ó¶ÀÁ¢¹ÜÀíµ¥Ôª”´°¿Ú£¬È»ºóµ¥»÷“È·¶¨”ÒԹرՓÌí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª”´°¿Ú¡£
        ÔÚ“¿ØÖÆ


Ïà¹ØÎĵµ£º

ʹÓÃSQL ServerµÄOPENROWSETº¯Êý

¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL Server±íµ¼ÈëÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬Äã¿ÉÒÔÔÚT-SQL(Transact-SQL£¬Î¢Èí¶ÔSQLµÄÀ©Õ¹)ÖÐÓÃOPENROWSETº¯Êý¸øÊý¾ÝÔ´´«ÈëÒ»¸öÁ¬½Ó´®ºÍ²éѯÀ´ÌáÈ¡ÐèÒªµÄÊý¾Ý¡£
¡¡¡¡Äã¿ÉÄܳ£³£»áÐèÒªÔËÐÐÒ»¸öad hoc²éѯ´ÓÔ¶³ÌOLE DBÊý¾ÝÔ´ÌáÈ¡Êý¾Ý£¬»òÕßÅúÁ¿ÏòSQL ......

ʹÓÃXMLÔÚSQL ServerÉÏ´´½¨¼ÆËãÁÐ

¡¡ÔÚSQL ServerÊý¾Ý¿âÖУ¬µ±ÄãÏëʹÓÃÒ»¸öÊý¾Ý£¬¶øÕâ¸öÊý¾Ý²»±£´æÔÚ±íÖУ¬¼ÆËãÁкÜÓÐÓá£ÀýÈ磬ÄãÓÐÒ»ÕÅ±í£¬Ëü°üÀ¨ÁÐdollar amounts, wholesale pricesºÍretail prices¡£Äã¿Ï¶¨²»ÏëÔÚÿ´Î²éѯ±íʱÀ´¼ÆËãÄÇÁ½ÁÐÖ®¼äµÄ²îÖµ£¬ÄãÏ£Íû½«ÆäÖµ±£´æÔÚµÚÈýÁÐÖУ¬ÈÃÆä×Ô¶¯¼ÆËãÇ°Á½ÁÐÖ®¼äµÄ²îÖµ¡£¶ø´ËÁоÍÊǼÆËãÁС£
¡¡¡¡ÔÚSQL ServerÖ ......

SQlÖÐSTUFFÓ÷¨

1¡¢×÷ÓÃ
     ɾ³ýÖ¸¶¨³¤¶ÈµÄ×Ö·û£¬²¢ÔÚÖ¸¶¨µÄÆðµã´¦²åÈëÁíÒ»×é×Ö·û¡£
2¡¢Óï·¨
     STUFF ( character_expression , start , length ,character_expression )
3¡¢Ê¾Àý
     ÒÔÏÂʾÀýÔÚµÚÒ»¸ö×Ö·û´® abcdÖÐɾ³ý´ÓµÚ 2 ¸öλÖã¨×Ö·û b£©¿ªÊ¼µÄÈý¸ö×Ö·û£¬È ......

SQLÖаѲéѯ³öÀ´µÄ½á¹ûÓöººÅÁ¬½ÓÆðÀ´

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µÄֵΪ ......

oracle pl/sql ±à³Ì

                                              µÚÒ»²¿·Ö  »ù±¾¸ÅÄî
Ò»¡¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ