select *
from tablename
where CONVERT(xml, Sections).value('(/sections/section/@value)[1]', 'varchar(1)') = 'f'
select *
from tablename
where CONVERT(xml, Sect
阅读背景：
SQL Server XML类型从任何标记中选择Where = Attribute = X.
来源：互联网
分享到：
