/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 vote235 views1 answer
Mysql sum with group by
SQL
5 votes242 views3 answers
Mysql remove unique constraint
SQL
0 vote240 views1 answer
Database db connection string format
SQL
0 vote223 views1 answer
Oracle sql generate list of days
SQL
0 vote213 views1 answer
Mysql page segment
SQL
0 vote216 views1 answer
Truncate table sql server foreign key
SQL
13 votes232 views5 answers
Sql default
SQL
2 votes224 views1 answer
Mysql find tables with name
SQL
0 vote219 views1 answer
How to use lower case in mysql
SQL
0 vote230 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL