Using custom types in SQL server Stored procedure to pass list of values

1

Hi ,

I am using a MS SQL stored proc to do some database work.
I want to pass a list of values to this proc ( like an array ) of integers or strings 'string1', 'string2' etc and 1,2,3,5,6 etc.

can we use a custom type declared as a table of int or strings .

like

CREATE TYPE dbo.integerList
AS TABLE
(
  id INT
);
CREATE TYPE dbo.sringList
AS TABLE
(
  id varchar(50)
);

any tips does Radzen supports this  ? 

Best regards, Mehmet
2

Hi,

You do not need additional types to pass list of string/int to your stored procedure parameters.

3

Hi ,
How do we do this in Radzen ?

4

Here is an excellent article: http://www.sommarskog.se/arrays-in-sql.html

5

Alternative suggested works also.
Thank you,