How to add many Parameters to ExecuteNonQuery, for IN() function in Sql?

Help
,
1

I add ExecuteNonQuery activity as picture below.

1
11519×509 113 KB

I set Sql as code and picture below.

UPDATE [dbo].[Calendar] SET [Active] = 0 WHERE [CalendarID] IN (@CalendarID)

2
2730×268 30.9 KB

First scenario, I have one CalendarID and set Parameters as picture below. It’s work, updated column in database.

3
31030×290 34.8 KB

Second scenario, I have two CalendarID and set Parameters as picture below. It’s not work.

4
41030×290 46.4 KB

Could someone please help to suggest me?

1 Like
2

Try with the following value,
"'value1','value2'"

3

@KarthikByggari, I had tried for both picture below. It’s still not work for both.

5
51030×290 34.9 KB

6
61030×290 37 KB

4

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.

http://www.sommarskog.se/arrays-in-sql.html

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f8cf78f5-f35c-47cd-9de9-63400565fd50/use-multiple-values-from-parameters-in-tsql-query?forum=transactsql

Regards,
Karthik Byggari

1 Like
5

@KarthikByggari, Thank you very much for the concept.

1 Like
6

Can you tell me, how to use the in arguments inside the query???..
@akkapolk

7

Hi @akkapolk,

Here is the sample project for passing parameter to the ExecuteNonQuery…

Regards
Balamurugan.S

1 Like