Here is a solution which will be definitely of help to you :-
declare @val xml
set @val = '<PARAMS>
<Experience HeadId="9" MinExp="4" MaxExp="5" Rate="45" />
<Experience HeadId="29" MinExp="6" MaxExp="8" Rate="76" />
<Experience HeadId="31" MinExp="9" MaxExp="12" Rate="90" />
<Experience HeadId="32" MinExp="13" MaxExp="18" Rate="100" />
<Experience HeadId="33" MinExp="19" MaxExp="50" Rate="200" />
</PARAMS>';
SELECT x.node.value('(@HeadId)[1]', 'int') As HeadId,
x.node.value('(@MinExp)[1]', 'int') AS MinExp,
x.node.value('(@MaxExp)[1]', 'int') AS MaxExp,
x.node.value('(@Rate)[1]', 'int') AS Rate
FROM @val.nodes('/PARAMS/Experience') AS x(node)
Here @val is the xml type variable which holds the xml for me.
We can use any xml type column in place of this variable to get the values from it as requirement.