BizTalk Server Orchestration - Clearing database table with SQL updategrams?

Author

Clearing database table with SQL updategrams?

Theo

2005-10-12, 6:12 pm

I need to clear a table in the database from within my orchestration,
according to the following sql query:

Delete from Table

Is this achievable with SQL updategrams?

//theo

Marvin Smit

2005-10-12, 6:12 pm

Hi,

i'm not sure you can do that in a updategram (SQL experts, please
assist). But i am sure you can call a Stored Procedure to execute that
functionality.

Hope this helps,

Marvin Smit.

On Wed, 12 Oct 2005 01:41:11 -0700, "Theo"
<Theo@discussions.microsoft.com> wrote:

>I need to clear a table in the database from within my orchestration,
>according to the following sql query:
>
>Delete from Table
>
>Is this achievable with SQL updategrams?
>
>//theo
>