xquery - SQL XML query (value) returning no results -


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