Limitations of the XML Data Type are:
1
It cannot be compared or sorted. This means an XML data type cannot be used in a GROUP BY statement.
2
It cannot be used as a key column in an index.
3
The value() method of the XML data type returns a scalar value, so it can be specified anywhere where scalar values are allowed
4
1 and 2 is true
5
All of the options