/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

1 vote309 views1 answer
SQL date part only of datetime
SQL
0 vote324 views1 answer
Psql show db
SQL
0 vote305 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote316 views1 answer
Plpgsql raise notice
SQL
3 votes318 views2 answers
MySQL query to get column names
SQL
0 vote328 views1 answer
Update sql sintax
SQL
1 vote340 views3 answers
Reseed sql table primary key
SQL
3 votes293 views4 answers
Mysql delete duplicate rows
SQL
0 vote323 views1 answer
Watch mysql command line
SQL
0 vote268 views2 answers
Influxdb delete measurement based on date
SQL