你即將離開本站

並前往https://stackoverflow.com/questions/10344553/how-can-i-query-a-value-in-sql-server-xml-column

How can I query a value in SQL Server XML column

select Roles from MyTable where Roles.value('(/root/role)[1]', 'varchar(max)') like 'StringToSearchFor'. In case your column is not XML ...

確定！ 回上一頁

查詢 「SQL XML query」的人也找了：

  1. SQL XML query attribute value
    2.
  2. SQL XML value
    3.
  3. SQL XML like
    4.
  4. Parsing xml in sql
    5.
  5. Sql where xml
    6.
  6. DB2 XML query example
    7.
  7. SQL XML CROSS APPLY
    8.
  8. SQL XML to string
    9.