/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 vote136 views1 answer
Declarative base sqlalchemy
SQL
2 votes175 views1 answer
Tcl in sql
SQL
1 vote155 views1 answer
Oracle select row max date
SQL
0 vote173 views1 answer
Call function sql oracle with output put line
SQL
0 vote163 views1 answer
Sql to excel pgadmin
SQL
0 vote154 views1 answer
Postgres full text search example
SQL
0 vote140 views1 answer
Oracle procedure teamplate
SQL
0 vote156 views1 answer
Except in sql
SQL
0 vote144 views1 answer
Tsql pad left
SQL
0 vote104 views2 answers
Avg() sql
SQL