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.

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

Answer / surjit

Use it for SQL schema generation using Add Generated items
wizard.

Use it for Send and receive Port

Answer / abhi

when we use the SQL Adapter for generating Schemas, Port etc.

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>

Answer / purna

to update data into database we are using updatagram and to
retreving data from use stored procedures.

How can we process EDI file with out EDI pipeline.

1 Answers   Cap Gemini,

Explain about business activity services (bas)?

0 Answers  

What is document schema?

0 Answers  

define mapping,orchestration ,schema,adapters.pipelines,BRE,HAT,BAM ?

2 Answers  

Explain why messages are immutable inside biztalk?

0 Answers  

im completed my biztalk course , plz guide me how to get job ?

0 Answers  

what is custom pipeline and the use of custom pipeline ? why and how we use custom pipeline?

2 Answers  

Define bam?

0 Answers  

Can we get messages to Orchestration without using schema?

7 Answers  

what is the use of schema in biztalk and why we use schema?

0 Answers   IBM,

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?

1 Answers   Cognizant,

How to version your schema?

4 Answers