/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

12 votes347 views1 answer
Psql drop column
SQL
0 vote384 views1 answer
Sql query wordpress export post
SQL
0 vote323 views1 answer
Access refused mysql xampp server
SQL
0 vote360 views1 answer
How to update sql server version
SQL
1 vote355 views1 answer
Top 10 rows in mysql
SQL
5 votes355 views3 answers
Oracle first day of last year
SQL
0 vote348 views2 answers
Mysql unique two columns
SQL
2 votes332 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote356 views1 answer
Sql check if column exists
SQL
0 vote316 views1 answer
Oracle list all stored procedures
SQL