Home Forums SQL Server 2008 T-SQL (SS2K8) how to read xml variable using openxml RE: how to read xml variable using openxml
jos.moy
SSC Rookie
Points: 28
More actions
December 14, 2012 at 7:33 pm
#1568864
Hello
In a SQL to get the fields of XML to SQL query would be like this, not if you really want to take SQL.
select
campo.value('(/Encabezado/Heads_tree_XML)[1]','Data_type'')
from tabla
I hope to help you