/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

3 votes204 views2 answers
Plsql print
SQL
0 vote213 views1 answer
Max mysql
SQL
1 vote216 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote299 views1 answer
Example database query
SQL
1 vote238 views1 answer
Epoch time converter in snowflake
SQL
13 votes202 views2 answers
Sqlite rename column
SQL
0 vote210 views1 answer
Ajax error exception handeling
SQL
0 vote201 views1 answer
Apache Derby: Create SQL Dump with data
SQL
21 votes266 views3 answers
Average sql
SQL
1 vote221 views1 answer
Postgresql datetrunc too slow
SQL