/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

1 vote310 views1 answer
Mysql best tutorial for beginners
SQL
2 votes321 views1 answer
Mysql Incorrect column specifier for column
SQL
1 vote327 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote337 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote320 views1 answer
Get create sql of hibernqte entity
SQL
4 votes331 views1 answer
Postgresql list sequences
SQL
1 vote313 views1 answer
Insert column after column mysql
SQL
0 vote301 views1 answer
Mysql select last 15 minutes
SQL
0 vote296 views1 answer
Microsoft word insert sql code
SQL
0 vote342 views1 answer
Sql query wordpress export post
SQL