/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 vote115 views2 answers
Maximum number of tables in mysql
SQL
0 vote112 views1 answer
Mysql shell set time_zone
SQL
0 vote111 views1 answer
ORA-13717
SQL
0 vote111 views1 answer
Oracle archivemode
SQL
0 vote108 views1 answer
Alasql delete column
SQL
3 votes153 views2 answers
Mysql user permission database
SQL
10 votes75 views2 answers
Sql where clause multiple values
SQL
0 vote136 views1 answer
Sql order by number not ordered
SQL
0 vote109 views1 answer
Mysql streaming example
SQL
0 vote111 views1 answer
Will graphql replace sql
SQL