I have following XML stored in a XML column (called \[code\]Roles\[/code\]) in a SQL Server database.\[code\]<root> <role>Alpha</role> <role>Beta</role> <role>Gamma</role></root>\[/code\]I'd like to list all rows that have a specific role in them. This role passed by parameter.
How can I query a value in SQL Server XML column
- Thread starter SikeSaipt
- Start date