/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
Get server date mysql
SQL
1 vote287 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
4 votes277 views2 answers
Sql server date now
SQL
0 vote265 views1 answer
Mysql jdbc timezone
SQL
0 vote278 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote283 views1 answer
Drop-toys-table
SQL
0 vote288 views1 answer
Sql server user permissions and roles
SQL
0 vote319 views2 answers
Suse Linux restart MySQL
SQL
1 vote299 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
-1 vote279 views5 answers
Online sql to linq generator
SQL