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. Continue reading Sql Server Interview questions: What is the XML datatype?→
We can create variables, parameters, and columns of the xml datatype – if we associate a collection of XML schemas with a variable, parameter, or column of xml datatype. In this case, the xml datatype instance is called typed XML. Continue reading #SqlServer interview question: What is typed XML?→