SQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(2)
ÎÄÕµ¼º½ SQL Server 2005 ѧϰ±Ê¼ÇϵÁÐÎÄÕµ¼º½
ÔÚSQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1) ÀïÎÒÃÇ˵Á˹ØÓÚPath£¬RawºÍAutoģʽµÄÓ÷¨£¬ÆäʵÀïÃæ²»½ö½ö ÊÇÕâЩ¼òµ¥µÄ²Ù×÷£¬»¹ÓÐһЩÆäËüµÄÌØÐÔ£¬±ÈÈç˵Type»òOpenXml·½·¨£¬sp_xml_preparedocument´æ´¢¹ý³Ì µÈÕâЩÔö¼ÓµÄ¶«¶«£¬ÎÒÃÇÀ´Ò»¸öÒ»¸öµÄ¿´°É£¬
µÚÒ»¸öType¹Ø¼ü×Ö£¬Type´ó¼Ò¶¼ ÖªµÀ Ó¢ÎÄÒâ˼ÊÇÀàÐÍ£¬ÔÚÕâÀïÒ²ÊǺÍÀàÐÍÏà¹ØµÄ£¬Òâ˼¾ÍÊÇ˵ÈÃ×Ó¼¯ÀïÃæÀàÐͺͼ¯ºÏµÄÀàÐÍͳһ£¬¾ßÌå ÊÇÔõôͳһµÄÕâ¸öÎÒÒ²²»¶®£¬´ó¼Ò»¹µÃ×Ô¼ºÈ¥²é»òÊÇÕÒÕÒMSµÄÍøÕ¾°É£¬ÎÒÃÇ»¹ÓÃÉÏÒ»½ÚµÄÊý¾Ý¿âºÍ±íÀ´ÊµÏÖ¾ßÌå±íµÄ½á¹¹»¹Çë´ó¼Ò²Î¿¼SQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1)ÀïÃæµÄ ÎÒÃÇÀ´×öдһ¸öÕâÑùµÄ×Ó²éѯ
SELECT SID,SName,(SELECT ClassInfo.CName from ClassInfo WHERE ClassInfo.CID=Students.CID FOR xml raw)
from Students
ORDER BY CID FOR xml auto
ÎÒÃÇ¿ÉÒÔÇå³þµÄ¿´µ½×Ó²éѯ·µ»ØµÄÊÇÒ»¸öXmlÀàÐ͵ĶøÍâÃæµÄ¼¯ºÏÒ²ÊÇÒ»¸öXmlÀàÐ͵ģ¬Õâ¸öʱºòÈç¹ûÎÒÃÇÖ±½ÓÖ´ÐеĻ°¾Í»á·¢Éú´íÎó
ÏûÏ¢ 6809£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
²»Äܽ«Î´ÃüÃûµÄ±íÓÃ×÷ XML ±êʶ·û£¬Ò²²»Äܽ«Î´ÃüÃûµÄÁÐÓÃÓÚÊôÐÔÃû³Æ¡£ÇëÔÚ SELECT Óï¾äÖÐʹÓà AS ¶ÔδÃüÃûµÄÁÐ/±í½øÐÐÃüÃû¡£
ÎÒÃÇÖªµÀ Èç¹ûÊÇÕý³£µÄÇé¿öÏÂÊÇ¿ÉÒԵģ¬Î޷ǾÍÊÇÕâÒ»ÁÐûÓÐÁÐÃû£¬µ«ÊÇÊDz»»á±¨´íµÄ£¬ÄÇÕâ¸öʱºòÎÒÃǾͿÉÒÔÕâÑùÀ´Ð´ÁË
SELECT SID,SName,(SELECT ClassInfo.CName from ClassInfo WHERE ClassInfo.CID=Students.CID FOR xml raw,type)
from Students
ORDER BY CID FOR xml auto
Ö»ÒªÔÚ×Ó¼¯µÄºóÃæ¼ÓÉÏÒ»¸öType¾Í¿ÉÒÔÁË£¬ÎÒÃǵÄType¾ÍÊÇÔÚÕâÖÖÇé¿öÏÂʹÓõģ¬Ò²¿ÉÄÜÊÇÎÒÁ˽âµÄÌ«ÉÙÁË£¬ÎÒ¸öÈ˸оõ Õâ¸ö¶«¶«ÊÇûÓÐʲô̫´óµÄÓô¦µÄ£¬ÎÒÃÇ¿ÉÒÔÕâÑùÀ´Ð´
SELECT SID,SName,(SELECT ClassInfo.CName from ClassInfo WHERE ClassInfo.CID=Studen
Ïà¹ØÎĵµ£º
¿ª·¢¹ýAndroidÓ¦ÓõÄͬѧÃǶ¼ÖªµÀ£¬Android¹¤³Ì-res-layout×ÊÔ´Îļþ¼ÐÏ´æ·Å×Å¿ØÖÆview²¼¾ÖµÄxmlÎļþ£¬ÎÒÃÇ¿ÉÒÔͬ¹ýgetViewById(int i)·½·¨£¬´ÓXMLÖй¹Ôìview¼°Æä×ÓÀ࣬ÔÚÕâ¸ö¹ý³Ìµ±ÖУ¬XMLÎļþÖеÄÒ»ÇÐlayoutÊôÐÔÒ²½«±»¸³ÓèÕâ¸öview¡£µ±È»£¬ÎÒÃÇÒ²Äܹ»Í¨¹ý´úÂëÀ´ÎªÄ³Ò»¸öviewÀ´ÉèÖÃlayout£¬ÄÇÊǺ󻰡£Í¨¹ý¶Ô¼ ......
¹¤×÷ÖÐÓöµ½ÐèÒªºÏ²¢XMLµÄÎÊÌ⣬Ëì´ÓÍøÉϲéÕÒÏà¹Ø×ÊÁÏ£¬
1¡¢ ¡¶ XML merging made easy
¡·
2 ¡¢¡¶javaÖкϲ¢xmlÎĵµµÄÉè¼ÆÓëʵÏÖ
¡·
²âÊÔºó·¢ÏÖ¾ù²»·ûºÏʵ¼ÊÐèÇó£¬Êµ¼ÊÐèÇóÈçÏ£º
file1.xml:
<root>
<a>
<b name="1"/>
</a>
<d /& ......
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 ......
´Ó²©¿ÍÔ°Öп´µ½Ò»ÆªÎÄÕ£¬½éÉÜ´óÈí¼þ¹«Ë¾ÃæÊÔʱ³£³£»á³öµÄÁ½µÀSQLÌ⣨¼û¸½Â¼£©¡£
ÎÒ¾õµÃÊÜÒæºÜ¶à£¬ÔÚ´Ë֮ǰ£¬ÎÒÒ»Ö±¾õµÃ£¬SQL2008ËƺõÌṩÁËÕâ·½ÃæµÄÖ§³Ö£¬µ«¸üµÍµÄ°æ±¾£¬°üÀ¨2005£¬·ÇÓαê×ö²»³öÀ´£¨Ë®Æ½¹»²Ë£©¡£×ܽáÐĵÃÈçÏ£º
1¡¢ Ç¿´óµÄgroup by
1 select stdname,
2 isnull( ......
¡¡×î½üÔÚÕÛÌÚ PHP + MYSQL
µÄ±à³Ì¡£Á˽âÁËһЩ PHP SQL ×¢Èë¹¥»÷
µÄ֪ʶ£¬ÓÚÊÇдÁËÕâƪÎÄÕ¡¡http://www.xiaohui.com/weekly/20070314.htm£¬×ܽáһϾÑé¡£ÔÚÎÒ¿´À´£¬Òý·¢ SQL ×¢Èë¹¥»÷
µÄÖ÷ÒªÔÒò£¬ÊÇÒòΪÒÔÏÂÁ½µãÔÒò£º
¡¡¡¡1. php ÅäÖÃÎļþ php.ini ÖÐµÄ magic_quotes_gpc
Ñ¡ÏîûÓдò¿ª£¬±»ÖÃΪ off
¡¡¡¡2. ¿ª·¢ ......