/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 vote147 views1 answer
Create view in sql server that contain multiple select statements
SQL
18 votes138 views6 answers
Drop table if exists
SQL
0 vote138 views1 answer
Sql select with apostrohpe
SQL
2 votes138 views1 answer
Compare date in sql
SQL
0 vote144 views2 answers
Sql searching via key word
SQL
25 votes136 views5 answers
Date in mysql
SQL
6 votes144 views3 answers
Mysql create database utf8
SQL
0 vote147 views1 answer
Sql server list table sizes
SQL
0 vote163 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
4 votes133 views1 answer
Fetch first 10 rows in oracle sql developer
SQL