Question Locked
XQuery
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying this code in database
--------------------------------------
DECLARE @x XML
SET @x = ''
SELECT Table1.Column1.value('@name','VARCHAR(20)')
FROM @x.nodes('/christmaslist/person') as Table1(Column1)
--------------------------------
and getting error saying :
Incorrect syntax near '.'.