/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 vote121 views1 answer
Sample in sql
SQL
0 vote117 views1 answer
Mysql error codeigniter
SQL
0 vote121 views1 answer
Sql tablo sp
SQL
0 vote124 views1 answer
Sql period overlap
SQL
0 vote123 views1 answer
Stored function in sql
SQL
1 vote116 views1 answer
How to select multiple columns from different tables in mysql
SQL
1 vote125 views1 answer
How to fetch alternate records from two tables
SQL
18 votes111 views3 answers
Mysql add column default value
SQL
8 votes147 views6 answers
Insert command in sql
SQL
0 vote127 views2 answers
Get item by composite primary key mysql
SQL