
入门
复制declare @ data xml               set @ data =                <bookstore>            <bookcategory="COOKING">            <titlelang="en">Everyday Italian</title>            <author>Giada De Laurentiis</author>            <year>2005</year>            <price>30.00</price>            </book>            <bookcategory="CHILDREN">            <titlelang="jp">Harry Potter</title>            <author>J K. Rowling</author>            <year>2005</year>            <price>29.99</price>            </book>            <bookcategory="WEB">            <titlelang="en">XQuery Kick Start</title>            <author>James McGovern</author>            <author>Per Bothner</author>            <author>Kurt Cagle</author>            <author>James Linn</author>            <author>Vaidyanathan Nagarajan</author>            <year>2003</year>            <price>49.99</price>            </book>            <bookcategory="WEB">            <titlelang="cn">Learning XML</title>            <author>Erik T. Ray</author>            <year>2003</year>            <price>39.95</price>            </book>            </bookstore>            1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.      
作者:系统运维