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