/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 vote265 views1 answer
Sql constarint
SQL
2 votes250 views2 answers
Sql percentage
SQL
0 vote255 views1 answer
Allow null in psql
SQL
0 vote256 views1 answer
Psotgres multiple values
SQL
0 vote237 views1 answer
Complete date is 1 year or not sql server
SQL
25 votes259 views1 answer
How to update an attribute in MySQL
SQL
10 votes256 views2 answers
Tsql merge example
SQL
0 vote310 views2 answers
Mysql insert rows to another database
SQL
24 votes199 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote257 views1 answer
Group by 15 minute interval sql server
SQL