/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 vote341 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote360 views1 answer
SQL Server date literal
SQL
1 vote367 views2 answers
Oracle list service names
SQL
2 votes384 views2 answers
Create temporary table in mysql
SQL
0 vote336 views1 answer
Sql server cannot create database diagram
SQL
0 vote383 views1 answer
Look at running processes redshift
SQL
0 vote368 views1 answer
How to map sql column to custom names
SQL
0 vote334 views1 answer
Database get 10 user aleatory
SQL
0 vote328 views1 answer
Mysql select last 15 minutes
SQL
0 vote349 views1 answer
Create table database in psql
SQL