/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

6 votes186 views1 answer
Postgres get size of database
SQL
0 vote241 views1 answer
Oracle plsql sleep
SQL
0 vote177 views1 answer
Remove from table where
SQL
1 vote198 views1 answer
Postgres get month name from date
SQL
0 vote213 views1 answer
Create function in microsoft sql server
SQL
10 votes130 views2 answers
Django mysql
SQL
0 vote223 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote340 views2 answers
Create new table from existing table with data in sql server
SQL
13 votes184 views2 answers
Get tables in database sql
SQL
2 votes182 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL