how to convert xml to database table input:
Declare @OUT xml
select @OUT = N'
&lt;row&gt;
  &lt;kind&gt;MainCat&lt;/kind&gt;
  &lt;sortid&gt;1&lt;/sortid&gt;
  &lt;kind_id&gt;1&lt;/kind_id&gt;
  &lt;PPoet&gt;حافظ&lt;/PPoet&gt;
  &lt;MTitle&gt;حافظ&lt;/MTitle&gt;
  &lt;Row&gt;1&lt;/Row&gt;
&lt;/row&gt;'


select T.X.value('@Kind', 'nvarchar(50)') as kind,
T.X.value('@sortid', 'int') as sortid
from @out.nodes('/row') as T(X)

this select return NULL!
Very close:

select 
  T.X.value('./kind[1]', 'nvarchar(50)') as kind,
  T.X.value('./sortid[1]', 'int') as sortid
from @out.nodes('/row') as T(X);