___>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
___>;
___>