/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 vote96 views1 answer
How to find symmetric pairs in sql
SQL
0 vote113 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote109 views1 answer
My sql data file extention
SQL
1 vote119 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote106 views1 answer
Python mysql executemany
SQL
10 votes95 views4 answers
Primary key in sql
SQL
0 vote95 views1 answer
Search In the Database using Text
SQL
0 vote102 views1 answer
Oracle current session details
SQL
0 vote98 views1 answer
Sql view index
SQL
0 vote111 views1 answer
Every Derived yable must have its own alias
SQL