03-21-06 08:10 AM
> A question concerning the BizTalk SQL Adapter, can you call a store
> procedure and pass the message as a XML document to the store proc? If
> so can you explain how?
- I doubt you can pass an XML doc to a stored procedure. Althought you might
wanna double check on this one.
> Secondly if the answer is no to the above, how do you insert
> hierarchically structured XML messages with the BizTalk SQL Adapter?
- You can hierrachically structure XML message with BizTalk SQL Adapter by
using a FOR XML EXPLICIT clause. Please search online for more info. However
,
it may not allow to create a complicated XML structure with FOR XML EXPLICIT
in SQL 2000.
"docnyc@gmail.com" wrote:
> A question concerning the BizTalk SQL Adapter, can you call a store
> procedure and pass the message as a XML document to the store proc? If
> so can you explain how?
> Secondly if the answer is no to the above, how do you insert
> hierarchically structured XML messages with the BizTalk SQL Adapter?
>
>
[ Post a follow-up to this message ]
| 
