125 views

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 $\text{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. All of the options