Today, I have one requirement to check dynamically if a node exists in my xml or NOT.
I have a stored procedure that receives XML and I need to check if the message information xml contains one Node or NOT. If that node exists then I need to execute that Stored Procedure by different logic and if not it should run with different logic.
I figure it out by using EXISTS.
This is my XML, that I got as parameter.
So, I used this
That's it. I can write based on the return result by this statement.
Let me know if it helps you.
I have a stored procedure that receives XML and I need to check if the message information xml contains one Node or NOT. If that node exists then I need to execute that Stored Procedure by different logic and if not it should run with different logic.
I figure it out by using EXISTS.
This is my XML, that I got as parameter.
Now I need to check if "BulkData" node exists in XML, then I need to write different logic to get the result.DECLARE @ExportData XMLSELECT @ExportData ='<Data Number="A123"><BulkData><EachData Parts="Test1" /><EachData Parts="Test2" /><EachData Parts="Test3" /></BulkData></Data>'
So, I used this
This will return "1" if node is exists else return "0".SELECT @ExportData.exist('(//BulkData)')
That's it. I can write based on the return result by this statement.
Let me know if it helps you.
No comments:
Post a Comment