/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 vote246 views1 answer
Mysql average of multiple columns
SQL
0 vote257 views1 answer
How to use query in nosql
SQL
2 votes270 views1 answer
How to find constraints on a table in oracle
SQL
0 vote267 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote283 views1 answer
R write csv without index
SQL
4 votes243 views1 answer
SQL order random
SQL
7 votes265 views6 answers
Nth highest salary in sql
SQL
0 vote255 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote351 views1 answer
Create view in sql server that contain multiple select statements
SQL
27 votes269 views6 answers
Set password mysql
SQL