in which case you have to use updategram and stored
procedure?
Answer Posted / kavitha rajendran
If your case is the simple Add/Update-ing several rows, the
Updategram give you more simple way. You completely were
out of the SQL code.
SP give you more control under your data inside SQL. If you
also have SPs or
part of your business logic is/will be inside SQL you need
use SPs. Usually we have to use SP with OPENXML.
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
how to handle the error in soap
what are un-typed messages?
Is there any possibility in the biztalk FIFO(first-in-first-out) without use the orchestration? how to implement explain?
Explain about document schema and property schema?
What is convoy sets?
What is the default mapping for auto mapping? : biztalk server
What is correlation in context of biztalk server? : biztalk server
What is biztalk orchestrations dehydration and rehydration? : biztalk server
Difference between Biztalk server and web services?
Define hat?
In the dynamic send port actually we have to give the require destination details i.e, provided by client, but my question is how to get that particular address from where and where it is stored in biztalk?
What is the rules engine?
Define bre?
What are persistence points?
What is the difference between distinguished field and promoted property? : biztalk server