|
Home > Archive > BizTalk Server Orchestration > November 2005 > SQL adapter and conditional database operations
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL adapter and conditional database operations
|
|
|
| Hi!
In my application I'm using SQL updategrams in order to insert objects to
the database. Dependent on the content of the database I need to perform an
insert or an update. If an object already exists in the database I need to
update it (because one of the columns may be changed), if not, I have to
insert it into the database.
How can I achieve this in biztalk? Theoretically I would need to first
perform a select statement and upon the response decide if I should perform
an update or an insert. How can I implement this?
Thanks in advance,
theo
| |
| Feio Tomaz 2005-11-25, 5:51 pm |
| Hi Theo.
The best way to solve this problem will be use a store procedure and not
updategrams. This SP perform a select and decide if do a insert or update.
"Theo" wrote:
> Hi!
>
> In my application I'm using SQL updategrams in order to insert objects to
> the database. Dependent on the content of the database I need to perform an
> insert or an update. If an object already exists in the database I need to
> update it (because one of the columns may be changed), if not, I have to
> insert it into the database.
> How can I achieve this in biztalk? Theoretically I would need to first
> perform a select statement and upon the response decide if I should perform
> an update or an insert. How can I implement this?
>
> Thanks in advance,
>
> theo
|
|
|
|
|