/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 vote200 views2 answers
Oracle list service names
SQL
0 vote197 views1 answer
Mysql beautifier terminla
SQL
0 vote207 views1 answer
Sqlite insert or update
SQL
4 votes196 views4 answers
Rollback in sql
SQL
5 votes186 views1 answer
Mysql get last day of month
SQL
1 vote211 views1 answer
Psql connect to another database
SQL
0 vote206 views1 answer
Raiserror with nowait
SQL
1 vote223 views1 answer
Mysql remove last empty newline
SQL
1 vote208 views1 answer
Change table to innodb mysql
SQL
1 vote240 views1 answer
Psql client write to bash variable
SQL