/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 vote296 views1 answer
How to order result of subquery in select
SQL
1 vote310 views1 answer
How to use db.execute
SQL
0 vote301 views1 answer
Mysql wait_timeout
SQL
2 votes359 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote327 views1 answer
Create user faunadb
SQL
1 vote320 views1 answer
Login to database mysql terminal
SQL
0 vote309 views2 answers
Postgresql gset
SQL
1 vote319 views1 answer
T-sql find object by name
SQL
8 votes279 views1 answer
Oracle find text in functions
SQL
0 vote317 views1 answer
Set engine to innodb
SQL