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


Please Help Members By Posting Answers For Below Questions

how to handle the error in soap

2227


what are un-typed messages?

552


Is there any possibility in the biztalk FIFO(first-in-first-out) without use the orchestration? how to implement explain?

1668


Explain about document schema and property schema?

566


What is convoy sets?

535






What is the default mapping for auto mapping? : biztalk server

577


What is correlation in context of biztalk server? : biztalk server

512


What is biztalk orchestrations dehydration and rehydration? : biztalk server

610


Difference between Biztalk server and web services?

543


Define hat?

538


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?

1066


What is the rules engine?

600


Define bre?

600


What are persistence points?

513


What is the difference between distinguished field and promoted property? : biztalk server

537