/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

5 votes160 views1 answer
Sql check if date is between 2 dates
SQL
0 vote175 views1 answer
Search In the Data using ObjectName
SQL
1 vote150 views1 answer
Delete mysql from mac
SQL
-1 vote109 views2 answers
On delete set default sql server
SQL
2 votes144 views2 answers
Spring import sql
SQL
1 vote149 views1 answer
Regular expression in sql server
SQL
0 vote187 views1 answer
Joomla execute raw sql
SQL
0 vote137 views1 answer
CREATE MULTIPLE FK
SQL
0 vote187 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote201 views1 answer
Mql5 datetime get hour
SQL