Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what purpose does OPENXML clause have in sql server stored
procedure?

Question Posted / ynpradeep


what purpose does OPENXML clause have in sql server stored procedure?..

Answer / p.rajesh

OPENXML, a Transact-SQL keyword, provides a rowset over in-
memory XML documents that is similar to a table or a view.
OPENXML allows access to XML data as though it is a
relational rowset. It does this by providing a rowset view
of the internal representation of an XML document. The
records in the rowset can be stored in database tables.

OPENXML can be used in SELECT and SELECT INTO statements
wherever rowset providers, a view, or OPENROWSET can appear
as the source. For information about the syntax of OPENXML,
see OPENXML (Transact-SQL).

To write queries against an XML document by using OPENXML,
you must first call sp_xml_preparedocument. This parses the
XML document and returns a handle to the parsed document
that is ready for consumption. The parsed document is a
document object model (DOM) tree representation of various
nodes in the XML document. The document handle is passed to
OPENXML. OPENXML then provides a rowset view of the
document, based on the parameters passed to it.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

What is the maximum size of sql server database?

0 Answers  

What is public role in sql server?

0 Answers  

Security Question- SQL DBA exparts, need your help...

3 Answers  

What are the recovery models in sql server 2000?

0 Answers  

What are different types of replication in sql server?

0 Answers  

What is the need for indexing?

0 Answers  

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

What is a database in ms sql server?

0 Answers  

Why do we need different type of parameter?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories