/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

2 votes173 views1 answer
Postgresql drop primary key constraint
SQL
-1 vote184 views1 answer
Sql set max value in column
SQL
2 votes218 views1 answer
Oracle Column Names of a table
SQL
1 vote173 views1 answer
Oracle check table space
SQL
2 votes221 views1 answer
Query to check cpu utilization in oracle database
SQL
2 votes162 views1 answer
Postgresql update sequence next value
SQL
0 vote156 views1 answer
Postgresql create user roles
SQL
1 vote165 views1 answer
Sql bitwise operators
SQL
0 vote164 views1 answer
Oracle synonym procedure
SQL
0 vote168 views1 answer
Postgresql remove duplicate rows 2 columns
SQL