/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 vote143 views1 answer
Oracle boolean to varchar
SQL
0 vote175 views1 answer
What is the essence of SQL?
SQL
0 vote274 views1 answer
Modificar tipo de dato sql server
SQL
0 vote247 views1 answer
Suhaib
SQL
0 vote236 views2 answers
Insert data into multiple tables mysql
SQL
15 votes189 views2 answers
Select where duplicate mysql
SQL
0 vote172 views1 answer
Mysql date + 1 day
SQL
0 vote177 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote187 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote180 views1 answer
Number(10 2) in sql means
SQL