/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 vote209 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote161 views1 answer
Using SQL in rails migration
SQL
0 vote165 views1 answer
How to search query in python3 sqlite3
SQL
2 votes183 views2 answers
Checking data type in sql server
SQL
6 votes262 views2 answers
Non relational database
SQL
37 votes179 views3 answers
Duplicate records in sql
SQL
12 votes185 views4 answers
Mysql version
SQL
0 vote174 views1 answer
Postgres declare variable
SQL
18 votes168 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote198 views3 answers
Postgresql crete view
SQL