SQLServer实用教程(第三版)实验10SQLServer与xml

10SQLServerXML1.1SQLServerXML2XQuery3FORXML2.1XML2XML3XML4XQuery5FORXML3.1XMLEmploy.xml?xmlversion=1.0encoding=UTF-8?=000001//1966-01-23//=010008///1976-03-28///Employ,xmlXML2xmltableAuseYGGLGOcreatetabletableA(numintnotnullprimarykey,infoxmlnotnull,)OPENROWSETEmployXmlxmltableA3xmlxmlxmlXQueryxmlxmlqueryXQUERYeclare@xmldocxmlset@xmldoc='=000001//43//=000002//25////'[e-mail]('////')AS2.value()XMLchardeclare@xmldocxmldeclare@numberchar(6)set@xmldoc='=000001//43//=000002//25////'select@number=@xmldoc.value('(/////@)[1]','char(6)')[e-mail]@xmldocxmlset@xmldoc='=000001//46//'select@[e-mail]('insert1991-02-10/after(//)[1]')[e-mail]3forxmlrawrowuseygglgoselect*fromemployeeswhereworkyear3forxmlraw2.forxmlpathselectphonenumberas'@',employeeidas'/',nameas'/',workyearas'/'fromemployeeswhereeducation=''forxmlpath('')=83792361020010//2///=84708817102208//2///=83346722108991//4///AFORXMLPATH2000BFORXMLPATHFORXMLEXPLICIT