/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

2 votes119 views2 answers
Select multiple tables mysql
SQL
0 vote122 views1 answer
Delete insert record in sql server
SQL
1 vote138 views1 answer
Drop primary key oracle
SQL
0 vote121 views1 answer
Pgsql is not permitted to log in
SQL
0 vote112 views1 answer
Get only first row mysql
SQL
4 votes88 views1 answer
Oracle sleep
SQL
15 votes134 views6 answers
Laravel db transaction
SQL
3 votes144 views2 answers
Sql not contains
SQL
1 vote125 views2 answers
T-sql random number for each row
SQL
0 vote125 views1 answer
Mysql bash execute sql file
SQL