| Author |
SQL Adapter - Check before insert
|
|
|
| Hi,
In my orchestration, i have to send some data(100 fields) to one table
called X. Before sending this i have to check whether the data exists in the
table or not(18 fields). If not exists then insert it in x table.
How to do this in optimized way using SQL adapter
Thanks
Sents
| |
| Matt Milner 2004-12-09, 2:48 am |
| You could send the XML as a blob to SQL and then do insert/update logic
using OPENXML in the stored procedure to insert new rows and update existing
ones. I've got a sample on my blog that shows how to pass XML as a
parameter to a stored procedure.
matt
http://www.m3technologypartners.com/blogs/
"Sents" <Sents@discussions.microsoft.com> wrote in message
news:493AE61D-C859-4FDE-89F0-5F2D5A8748B6@microsoft.com...
> Hi,
>
> In my orchestration, i have to send some data(100 fields) to one table
> called X. Before sending this i have to check whether the data exists in
> the
> table or not(18 fields). If not exists then insert it in x table.
>
> How to do this in optimized way using SQL adapter
>
> Thanks
> Sents
| |
|
| Thanks Matt. I will try this.
I have made a return value field as distinguish field . How will i access in
decide shape.
It gives as Mutiresmsg.parameters thats it. it is not displaying field.??
Regards
Senthil
"Matt Milner" wrote:
> You could send the XML as a blob to SQL and then do insert/update logic
> using OPENXML in the stored procedure to insert new rows and update existing
> ones. I've got a sample on my blog that shows how to pass XML as a
> parameter to a stored procedure.
>
> matt
> http://www.m3technologypartners.com/blogs/
>
>
> "Sents" <Sents@discussions.microsoft.com> wrote in message
> news:493AE61D-C859-4FDE-89F0-5F2D5A8748B6@microsoft.com...
>
>
>
| |
| Matt Milner 2004-12-09, 8:48 pm |
| You have to do MPMessage.partname.distinguishedFieldName. This should give
you what you need.
matt
"Sents" <Sents@discussions.microsoft.com> wrote in message
news:89C26C45-A32E-42DF-BB7C-3E7A18E24E86@microsoft.com...[vbcol=seagreen]
> Thanks Matt. I will try this.
>
> I have made a return value field as distinguish field . How will i access
> in
> decide shape.
> It gives as Mutiresmsg.parameters thats it. it is not displaying field.??
>
> Regards
> Senthil
>
> "Matt Milner" wrote:
>
|
|
|
|