I add ExecuteNonQuery activity as picture below.
I set Sql as code and picture below.
UPDATE [dbo].[Calendar] SET [Active] = 0 WHERE [CalendarID] IN (
First scenario, I have one CalendarID and set Parameters as picture below. It’s work, updated column in database.
Second scenario, I have two CalendarID and set Parameters as picture below. It’s not work.
Could someone please help to suggest me?
Try with the following value,
@KarthikByggari, I had tried for both picture below. It’s still not work for both.
Here IN is an operator. So it expects a set of values but not string value.
That’s why it is failing. There are alternative ways how to pass the list of values as a parameter.
Please check the below links for an idea.
@KarthikByggari, Thank you very much for the concept.
Can you tell me, how to use the in arguments inside the query???..
Here is the sample project for passing parameter to the ExecuteNonQuery…
I made a test what @Pablo_Sanchez mentioned with a little table. It is working fine. can you attache the table script and your insert query as a zip file. May be it helps to do the analysis.
But any way, Here I have attached xaml and table for your reference.
SqlServer.zip (2.7 KB)