董晓涛(David Dong)

摘要： the following is the SP demo: usingSystem; usingSystem.Data; usingSystem.Data.Sql; usingSystem.Data.SqlServer; usingSystem.Data.SqlTypes; publicpartialclassStoredProcedures { [SqlPr... 阅读全文

摘要： XQuery is a language for XML data.XQuery syntax includes and extends XPaths 2.0 expressions and makes it possible to perform complex queries against on XML data source. An XQuery path is based on the ... 阅读全文

摘要： there are typed XML and Untyped XML that SQL Server 2005 Support. to use Untyped XML,you must have formet XML.and you can implict and emplict varchar to XML. to use typed XML,you must register XML ... 阅读全文

摘要： In SQL Server 2000, you can use a varchar, nvarchar, text, or ntext variable to generate a document handle using the sp_xml_preparedocument stored procedure. In SQL Server 2005, you can also use an x... 阅读全文

摘要： In SQL Server 2000, RAW mode FOR XML queries can return only attribute-centric XML. In SQL Server 2005, you can use the ELEMENTS directive with RAW mode queries to return element-centric XML. The foll... 阅读全文