By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| rn | value |
|---|---|
| 1 | One |
| 2 | Two |
| 3 | Three |
| 4 | Four |
Msg 493 Level 16 State 1 Line 8
The column 'node' that was returned from the nodes() method cannot be used directly. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.