/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 vote267 views2 answers
Advantages of stored procedures sql
SQL
3 votes418 views6 answers
Sql unique select
SQL
0 vote257 views1 answer
Azure sql server check foreign key
SQL
5 votes239 views2 answers
Mysql where in array
SQL
42 votes318 views6 answers
Sql query duplicate rows
SQL
0 vote247 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote265 views3 answers
Joins and views sql
SQL
0 vote263 views1 answer
Postgres get database encoding
SQL
1 vote255 views1 answer
Pv mysql import
SQL
2 votes271 views2 answers
Mysql bidirectional composite primary key
SQL