/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 vote177 views1 answer
Change date format in oracle query
SQL
15 votes162 views2 answers
How to drop database name in postgresql
SQL
0 vote162 views3 answers
Drop multiple columns in sql
SQL
0 vote176 views2 answers
Sql use not in
SQL
3 votes174 views1 answer
Query less than datetime sql
SQL
0 vote171 views1 answer
Frename oracle
SQL
2 votes178 views1 answer
Oracle virtual column
SQL
0 vote176 views2 answers
Drop tables from local table database postgres
SQL
0 vote194 views1 answer
Mysql bind-address default value
SQL
4 votes165 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL