![]() |
От: | _d_m_ | |
Дата: | 16.07.09 02:42 | ||
Оценка: | 2 (1) |
select
@name,
K.N.value('./@type', 'int') as RestrictType,
K.N.value('.', 'nvarchar(max)') AS RestrictValue
from
@xml.nodes('/col') as C(R)
cross apply
C.R.nodes('./r') as K(N)
where
C.R.value('./@name', 'varchar(128)') = @name
;