/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 vote132 views1 answer
Oracle list subpartitions
SQL
0 vote191 views1 answer
Radius search with point data in mysql
SQL
0 vote178 views1 answer
Offset in postgresql example
SQL
3 votes86 views2 answers
Mysql sum with condition
SQL
0 vote148 views1 answer
Insert into select with group by
SQL
0 vote94 views1 answer
Update sql join multiple tables
SQL
8 votes138 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote138 views1 answer
Azure sql server check foreign key
SQL
14 votes144 views5 answers
Sql oracle limit
SQL
2 votes138 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL