/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 vote296 views1 answer
Import sql mysql ubuntu
SQL
0 vote334 views1 answer
Oracle procedure chain step
SQL
0 vote320 views1 answer
Order by ip address sql
SQL
3 votes388 views3 answers
Update con select postgresql
SQL
1 vote334 views1 answer
Error code 1175 mysql fix
SQL
9 votes361 views4 answers
Mysql set id auto increment
SQL
0 vote532 views1 answer
Multiple row join
SQL
2 votes340 views1 answer
Mysql now format
SQL
0 vote266 views1 answer
<script>alert
SQL
4 votes334 views3 answers
Copy table postgres
SQL