here is my sample xml
<NewDataSet>
<Employee>
<EmpID>1005</EmpID>
<Name> keith </Name>
<DOB>12/02/1981</DOB>
<Salary>10,500</Salary>
</Employee>
</NewDataSet>
from where i want to extract data and store in string variable like this way
SET @Data='EmpID=1005,Name='Keith',DOB='12/02/1981',Salary=10,500'
so show me the way to extract data from xml and re-arrange or store data in string variable the way i want but please give me suggested sql in such way which should work for different or any xml template. looking for idea. thanks
No comments:
Post a Comment