0 votes
in NoSQL by
XML data types in SQL Server

1 Answer

0 votes
by

In SQL Server XML data types is very common data types these days we Use XML Data types to store unstructured or heterogeneous. Because XML is also very useful every where in these days like for business to coordinate, exchange of data and for collaborate we use XML.

From SQL Server 2005 a new data type XML is introduced where we can store XML data. With the help of this data type we can store either a complete XML document or a fragment of XML. Before this data type we will use varchar or text data type to store XML. But this will only use to store not to querying or manipulationg XML data. It will also raised XML validation issues. So this XML data type is introduced. These days, we store all data in the relational model with a dynamic column structure. In past we will store XML document in the file system which will create problem to handle that some

time physical store create issue. And sometime we will face issue to do read/write operation on this documents.

And now comes to topic why we need that as we know every industry must have unstructured data and to store that we use this XML data Types.

Related questions

0 votes
asked May 23, 2020 in NoSQL by Robindeniel
+1 vote
asked Aug 15, 2022 in NoSQL by AdilsonLima
...