I have XML
<persons> <person> </person> .... </persons>
I need to perform UPDATE or INSERT for each <person> in one transacion.
Will this SQL XML work?
<STATEMENT>
<TABLE_NAME action="UPDATE_INSERT">
<table>realDbTableName</table>
...
</TABLE_NAME>
<TABLE_NAME action="UPDATE_INSERT">
<table>realDbTableName</table>
...
</TABLE_NAME>
...
</STATEMENT>
Is it posible to prevent UPDATE if the data in <parson> are the same like in DB TABLE?