i'm trying understand value() method of querying xml can't seem return results...
create table userlisting (data xml) declare @xmlvalue xml set @xmlvalue = (select * users xml path ('user'), root ('userlisting'), type) insert userlisting values (@xmlvalue) query:
select data userlisting returns:
<userlisting> <user> <userid>bob</userid> <emailaddress>bob@bob.com</emailaddress> </user> <user> <userid>bill</userid> <emailaddress>bill@bill.com</emailaddress> </user> </userlisting> query:
select data userlisting data.value('(/userlisting/user/userid)[1]', 'varchar(max)') 'bob' ...no results, column header returned?
Comments
Post a Comment