|
stepson
Yak Posting Veteran
Romania
85 Posts |
 Posted - 04/27/2012 : 01:54:03
|
declare @xml as xml
set @xml='<NewDataSet>
<Table1>
<TableName>T_NCO_LNK_AST_AC_MISSN_VARNT</TableName>
<FieldName>EFF_DT</FieldName>
<FieldValue>123</FieldValue>
</Table1>
<Table1>
<TableName>T_OBJ</TableName>
<FieldName>OBJ_RID</FieldName>
<FieldValue>1</FieldValue>
</Table1>
</NewDataSet>'
select
q.t.value('TableName[1]','varchar(50)') as tableName,
q.t.value('FieldName[1]','varchar(50)') as FieldName,
q.t.value('FieldValue[1]','varchar(50)') as FieldValue
from @xml.nodes('/NewDataSet/Table1') as q(t) |
 |
|
create a procedure to read XML and get data
