Â¥Ö÷

ÔÚsql:queryÖÐʹÓòÎÊý½øÐÐÄ£ºý²éѯÓöµ½µÄÎÊÌ⣮¼±Çó°ï森£®£®[ÇóÖú] Ò»¸ö²âÊÔ²ÎÊýµÄÓÃÀýÈçÏ£º <?xml version="1.0" encoding="UTF-8"?> <root xmlns:sql='urn:schemas-microsoft-com:xml-sql'> <sql:header>  <sql:param name='na'>a</sql:param> </sql:header> <sql:query>  select * from book  where name like '%@na1%'  for XML auto,elements </sql:query> </root> ¿ÉÊÇÎÒÖ´Ðкó²é²»³ö½á¹û £ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß ¿ÉÊǸijÉÈçϲ»ÓòÎÊý¿ÉÒÔÕÒ³ö½á¹û£º <?xml version="1.0" encoding="UTF-8"?> <root xmlns:sql='urn:schemas-microsoft-com:xml-sql'> <sql:query>  select * from book  where name like '%a%'  for XML auto,elements </sql:query> </root> ÕÒ³öµÄ½á¹û£º   <?xml version="1.0" encoding="UTF-8" ?> - <root xmlns:sql="urn:schemas-microsoft-com:xml-sql"> - <book>   <id>1</id>   <name>Beginning ASP.NET 1.1 With Visual C#.NET 2003</name>   <ISBN>7-302-09148-X</ISBN>   <author>Chris Ullman John Kauffman</author>   <publisher>WROX PRESS.LTD</publisher>   <price>30</price>   </book> - <book>   <id>2</id>   <name>Design Patterns Elements of Reusable Object-Oriented Software</name>   <ISBN>7-111-09507-3</ISBN>   <author>Erich Gamma Richard Helm Ralph Johnson John Vlissides</author>   <publisher>Pearson Education</publisher>   <price>38</price>   </book> - <book>   <id>3</id>   <name>UML Distilled: A Brief Guide to the Standard Object Modeling Language</name>   <ISBN>ISBN 0321193687</ISBN>   <author>Martin Fowler</author>   <publisher>Addison-Wesley</publisher>   <price>34</price>   </book>   </root> £ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß£ß ΪʲôÎÒÓòÎÊýÎÞ·¨ÊµÏÖÕâÖÖÄ£ºý²éѯÄØ£¿°ÝÍдó¼Ò°ïÎÒÏëÒ»¸ö°ì·¨£®¼±£¡    Êղؠ  ·ÖÏí   ¶¥(0)