BizTalk Server Orchestration - SQL UpdateGram

BizTalk Server Orchestration - SQL UpdateGram - Update or Insert

This is Interesting: Free IT Magazines

Home > Archive > BizTalk Server Orchestration > August 2004 > SQL UpdateGram - Update or Insert

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 UpdateGram - Update or Insert

Ashish Udas

2004-08-12, 5:50 pm

I trying to use SQL - UpdateGram where I want to try update a record first,
if it failed(Since record does not exists) I want to Insert the same record.
I used update updategram it just thrown exception(Record does not exists)
and terminates thes service.

Is it possible with updategram?I can write SP but I have same scenario for
20 odd tables.

Thanks,in advanced.
Ashish Udas