BizTalk Question:
Download Job Interview Questions and Answers PDF
In which case you have to use updategram and stored procedure?
Answer:
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.
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.
Download BizTalk Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are convoys? | Define mapping,orchestration, schema, adapters.pipelines, BRE, HAT, BAM? |