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 ‘.’.
