What is the purpose of FOR XML in SQL Server?
Answer
SQL Server 2000 provides the facility to retrieve data in the form of
XML with the help of the FOR XML clause appended to the end of a SELECT
statement.
There are 3 types of FOR XML modes — RAW, AUTO, and EXPLICIT.
They all generate a different style of XML document
What is the OPENXML statement in SQL Server?
Going through thousands of lines of XML degrades performance to a great
extent.This is where the OPENXML function comes into use. It does the parsing
work for you quite efficiently.
The syntax of OPENXML is:
OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]]) [WITH
(SchemaDeclaration | TableName)]
OPENXML function is supposed to be used with two system stored procedures:
1.sp_xml_preparedocument
2.sp_xml_removedocuments
|
More XML Links
Answer - XML, Extensible Markup Language, is an open, text
based markup language that provides structural and semantic information to
data...............
Answer - They must have a root tag, the document should be well
formed : the tags should be properly closed, since XML is case sensitive, one
should take care..............
Answer - XML DTD is a rule book that an XML document follows.
Once DTD is ready, you can create number of XML documents following the same
rules..............
|
|