/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

8 votes136 views2 answers
Safe update mode in mysql
SQL
0 vote213 views3 answers
Insert or ignore postgres
SQL
0 vote134 views1 answer
Allow external access to mysql
SQL
0 vote112 views1 answer
Login phpmyadmin without password
SQL
0 vote152 views1 answer
Ubuntu connect to mssql database
SQL
0 vote131 views2 answers
Plan d'exécution requete oracle autotracer
SQL
5 votes132 views3 answers
Oracle list columns in schema
SQL
1 vote120 views1 answer
Error code 1055
SQL
11 votes130 views1 answer
Ddl materialized view
SQL
0 vote135 views1 answer
Vs 2019 connect to local mysql database
SQL