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
Did you deploy BizTalk more than one machine?
What is the difference between distinguished field and promoted property? : biztalk server
What is custom pipeline and the use of custom pipeline?
Explain about biztalk server messaging services?
What is the default mapping for auto mapping? : biztalk server
Explain about static, dynamic and direct binding?
What is property schema?
What is correlation in context of biztalk server? : biztalk server
Difference between field and promoted property?
What is the rules engine?
Define mapping?
Define adapters?
Difference between Biztalk server and web services?
Why and how we use custom pipeline?
I have a receive port and send port whose message types are different.When I receive a message in my receive port,my process starts.I will construct my out message and give this to my send port.I am configuring a send port group to the logical send port.TO the send port group I have added many send ports with filters.The message in the send ports are not getting filtered based on my filters?