To learn what is the benefit of
SET ARITHABORT ON
comment it out in the procedure and see what happens.
Or read this page :
http://msdn.microsoft.com/en-us/library/ms190306.aspx[
^]
and about
"What is the meaning of doc(col)"
It means that create a table named
doc
and insert xml nodes from
@xmlTbl.nodes('/DWR/Insertxml')
into a column named
col
So I think
doc.col.value
makes sense now.
Hope it helps.