The XML datatype holds and understands valid XML streams pretty much the same way that integers hold numbers with no decimal points, varchars hold strings of varying length, and the Geography datatype holds a position on the earth. 

The xml datatype lets you store XML documents and XML fragments in a SQL Server database.

An XML fragment is an XML instance that has a missing single top-level ROOT element.

You can create columns and variables of the xml datatype and store XML instances in them. The xml datatype and associated methods help integrate XML into the relational framework of SQL Server.

The XML datatype provides a valid way of passing large amounts of data as parameters to stored procedures.

Thanks for reading this article,

Next steps,

1. Share this with your colleagues because Sharing  is Learning
2. Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!