Passing Array in where condition in sql

Asked May 27 '18 at 15:24

Active May 27 '18 at 15:24

Viewed 22 times

I am using following stored in sqlserver, I can't figure out to pass array in this stored procedure. The array is exactly in this format from c# code ABC,DEF or i can write string abc = "ABC,DEF";

ALTER PROCEDURE [dbo].[BookedChemicalsLists]
        @RigNameValue VARCHAR(50) = null
AS
BEGIN
      SET NOCOUNT ON;   

      SELECT *
      FROM [BookedChemicals]
      WHERE AND (RigName IN (@RigNameValue,',') OR @RigNameValue IS NULL )
END

asked May 27 '18 at 15:24

Nabeel Mahmood

I agree this is a duplicate, however, don't use the first 2 answers. – Thom A May 27 '18 at 15:32
Can you please guide based on my query, i can't understand anything from there, it is different from what i am trying to do. – Nabeel Mahmood May 27 '18 at 15:34
Yes please, i can;t find solution from those questions. – Nabeel Mahmood May 27 '18 at 15:35
which version of SQL Server - that duplicate question specifically stated SQL Server 2008 and there are better ways to do it now. – paul May 27 '18 at 15:35
I am using SQL Server 2017 – Nabeel Mahmood May 27 '18 at 15:36
Thanks, i found the answer: – Nabeel Mahmood May 27 '18 at 15:38
(RigName IN (SELECT [value] FROM STRING_SPLIT(@RigNameValue, ',')) OR @RigNameValue IS NULL ) – Nabeel Mahmood May 27 '18 at 15:38
SQL Server 17 supports STRING_SPLIT which is heaven for me. – Nabeel Mahmood May 27 '18 at 15:39

Passing Array in where condition in sql

0 Answers0