Use XML to convert to table to transfer the table structure in SQL Parameters

In SQL 2005, the table structure is usually transferred in SQL parameters. The simplest way is to convert the data into a table using XML

Code Declare @ H   Int ,
@ XML   Varchar ( 8000 ),
@ 2k5 XML

Select @ XML   = '
<JRT>
<Item>
<ID> 11 </ID>
<Name> CS tester </Name>
<Company> EEE </company>
<Phone> 555-555-1234 </phone>
</Item>
<Item>
<ID> 22 </ID>
<Name> CS tester </Name>
<Company> EEE </company>
<Phone> 555-555-1234 </phone>
</Item>
</JRT>
' ,
@ 2k5   =   @ XML

Select T. C. Query ( ' ID ' ). Value ( ' . [1] ' , ' Varchar (100) ' ) As ID,
T. C. Query ( ' Name ' ). Value ( ' . [1] ' , ' Varchar (50) ' )AsName,
T. C. Query ( ' Company ' ). Value ( ' . [1] ' , ' Varchar (50) ' ) As Company,
T. C. Query ( ' Phone ' ). Value ( ' . [1] ' , ' Nvarchar (50) ' ) As Phone
From @ 2k5 . Nodes ( ' /JRT/item ' ) As T (c)

The result is:

ID name company phone
----------------------------------------
11 CS tester EEE 555-555-12
22 CS tester EEE 555-555-12