/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 vote393 views1 answer
Mysql dump with table query
SQL
4 votes365 views2 answers
How to insert ip address in mysql using php
SQL
6 votes411 views2 answers
How to get last element sql
SQL
1 vote358 views1 answer
Blob datatype in mysql
SQL
0 vote336 views1 answer
SQL Server format datetime
SQL
0 vote360 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote367 views1 answer
Table or view does not exist
SQL
3 votes375 views2 answers
To_char sql
SQL
0 vote357 views2 answers
SQL BULK INSERT
SQL
0 vote365 views5 answers
Select concat alter table mysql
SQL