/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 vote151 views1 answer
Postgresql check total storage
SQL
2 votes152 views1 answer
Query any digits record
SQL
1 vote147 views1 answer
Postgres delete from where date is greater than specific date
SQL
8 votes137 views3 answers
Postgresql connection string c#
SQL
0 vote177 views1 answer
Mysql subtract month from timestamp
SQL
17 votes144 views3 answers
Cast in sql server
SQL
0 vote134 views1 answer
Order by monthly in sql
SQL
0 vote101 views2 answers
Sql query unique
SQL
0 vote148 views1 answer
Sql select min
SQL
0 vote153 views1 answer
Copied text from internet not inserting in mysql
SQL