in which case you have to use updategram and stored
procedure?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tulasiram
we will use updategram and storedprocedure when we want to
insert any information to database or we are selecting any
information from database
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / abhi
when we use the SQL Adapter for generating Schemas, Port etc.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prabhat shankar
This is way we can use updategram to update multiple rows
in BizTalk orchestration.
Using the updategram to insert and delete are very
straightforward. It's also easy to update one row of data
using the updategram in BizTalk. BizTalk SQL adapter seems
to be problematic when dealing with updating multiple rows
of data using updategram. SQL XML states that you need to
use the attribute "updg:id" to associate the records
enclosed in the <updg:before> and those enclosed in
<updg:after>
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / purna
to update data into database we are using updatagram and to
retreving data from use stored procedures.
Is This Answer Correct ? | 2 Yes | 0 No |
What are the components of biztalk server architecture?
Source schema has nodes First Name, Last Name and destination schema has node Name. How we can get data at destination so that we can have two instance of Name (without using orchestration).
What is content routing?
What is biztalk?
What is biztalk server? : biztalk server
Did you deploy BizTalk more than one machine?
In orchestration dynamic send port generally we have to give destination path details i.e provided by client, but my question is how to get that particular address from where and where is it stored?
What is the default mapping for auto mapping? : biztalk server
What is Message routing and Content routing?
Define orchestration
Is there any possibility in the biztalk FIFO(first-in-first-out) without use the orchestration? how to implement explain?
Why and how we use custom pipeline?