/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

6 votes211 views5 answers
Sql add months to date
SQL
0 vote212 views1 answer
Mysql min value row
SQL
5 votes205 views1 answer
Sysdate in oracle sql
SQL
0 vote220 views1 answer
How we can perform acid Operations in sql with examples
SQL
5 votes239 views2 answers
Functions
SQL
34 votes243 views6 answers
Alter table add foreign key mysql
SQL
0 vote207 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
2 votes217 views3 answers
How to check current user in mySQL
SQL
0 vote159 views1 answer
Check if has alpha characters sql
SQL
0 vote229 views1 answer
Vs 2019 connect to local mysql database
SQL