/SQL/Pass array parameter to stored procedure c#

Pass array parameter to stored procedure c#

CREATE TYPE dbo.IDList
AS TABLE
(
  ID INT
);
GO

CREATE PROCEDURE dbo.DoSomethingWithEmployees
  @List AS dbo.IDList READONLY
AS
BEGIN
  SET NOCOUNT ON;

  SELECT ID FROM @List; 
END
GO

Source: stackoverflow.com

Similar codes

1 vote340 views1 answer
Mysql select and count left join
SQL
3 votes378 views2 answers
See mysql users ubuntu
SQL
-1 vote329 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote362 views1 answer
FIND most frequent word in sql server
SQL
0 vote319 views1 answer
Trigger value from maltiple table to single table mysql
SQL
3 votes329 views2 answers
Oracle drop column
SQL
1 vote322 views1 answer
How to make a select in sql
SQL
0 vote328 views1 answer
Get sum sqlite android
SQL
1 vote324 views1 answer
Postgresql blocked on mac
SQL
0 vote320 views1 answer
How to create a table in sql stack overflow
SQL