/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

0 vote287 views1 answer
Table or view does not exist
SQL
1 vote225 views1 answer
Ms sql - add one hour to time
SQL
1 vote279 views4 answers
Postgres extract date from timestamp
SQL
0 vote297 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote278 views1 answer
Sql server order by nulls last
SQL
12 votes280 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote287 views2 answers
Sql trigger difference between for and after
SQL
1 vote272 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote273 views1 answer
Mysql drop multiple tables at once
SQL
0 vote284 views1 answer
Prepared statement mysql java delete selected rows
SQL