declare @aa xml
set @aa='<r><f s=''aa'' e=''bb'' u=''cc''></f></r>'
SELECT T.row.value('@s', 'nvarchar(100)') AS serviceId ,
T.row.value('@e', 'nvarchar(100)') AS feedType ,
T.row.value('@u', 'nvarchar(100)') AS sourceType
FROM @aa.nodes('/r/f') AS T ( row
转载于:https://www.cnblogs.com/kym/archive/2010/07/26/1785485.html