xml parameter in sql server stored procedure
- by npalle
I want to write a stored procedure that accept an XML parameter, parsing it's elements and inserting them in a table SQL. This is my XML:
<Lines>
<Line>
<roomlist>
<room>
<namehotel>MeSa</namehotel>
<typeroom>506671</typeroom>
…