--建立测试数据DECLARE @T TABLE(
id INT IDENTITY,
ScreenSetGroups XML
)INSERT @T(ScreenSetGroups)
SELECT '<Groups> <ID>123</ID> <ID>456</ID> <ID>122</ID> <ID>44444</ID> </Groups>'
UNION ALL
SELECT '<Groups> <ID>123</ID> <ID>456</ID> <ID>789</ID> </Groups> '
UNION ALL
SELECT '<Groups> <ID>123</ID> <ID>111</ID> <ID>789</ID> </Groups>' --SQL查询如下:SELECT id, ScreenSetGroups
FROM @T
WHERE (ScreenSetGroups.exist('/Groups/ID[.="122"]') = 1)
id INT IDENTITY,
ScreenSetGroups XML
)INSERT @T(ScreenSetGroups)
SELECT '<Groups> <ID>123</ID> <ID>456</ID> <ID>122</ID> <ID>44444</ID> </Groups>'
UNION ALL
SELECT '<Groups> <ID>123</ID> <ID>456</ID> <ID>789</ID> </Groups> '
UNION ALL
SELECT '<Groups> <ID>123</ID> <ID>111</ID> <ID>789</ID> </Groups>' --SQL查询如下:SELECT id, ScreenSetGroups
FROM @T
WHERE (ScreenSetGroups.exist('/Groups/ID[.="122"]') = 1)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货