BizTalk Server General - Delete and Insert problem

Author

Delete and Insert problem

Tomasz Krupa

2005-08-23, 7:53 am

Hello,
I'm new in Biztalk so please explain me one thing. I need to modify table
Orders in my database in SQL Server - at first I must delete records with
specific value in column OrderNumber and after that there should be inserted
new orders. For this solution I used "Generated Items' and generate
Updategram. I'd read that to generate DELETE command there should be <after>
block and empty <before> and for INSERT empty <after> and filled <before>.
But how to do this on the schema? What is the best solution to this problem?
Thx for help

Nateshan

2005-08-24, 6:04 pm

1) I don't know the exact scenario but to do multiple operations on sql
server database Stored procedures are preferred. because they are compiled
and optimized compared to the interpreted Updategrams. Updategrams are used
to update fields occassionally into the database like....interest field of
the table.

bye....

"Tomasz Krupa" wrote:

> Hello,
> I'm new in Biztalk so please explain me one thing. I need to modify table
> Orders in my database in SQL Server - at first I must delete records with
> specific value in column OrderNumber and after that there should be inserted
> new orders. For this solution I used "Generated Items' and generate
> Updategram. I'd read that to generate DELETE command there should be <after>
> block and empty <before> and for INSERT empty <after> and filled <before>.
> But how to do this on the schema? What is the best solution to this problem?
> Thx for help