/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 vote280 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote263 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
4 votes268 views1 answer
Restart for pg_hba.conf file
SQL
0 vote255 views1 answer
What is the essence of SQL?
SQL
17 votes270 views3 answers
How to change a collumn name in sql
SQL
21 votes280 views4 answers
Oracle add column
SQL
1 vote301 views1 answer
Mysql curdate between two dates
SQL
0 vote310 views1 answer
Sql create and grant user access to database
SQL
-1 vote264 views3 answers
Mysql get age from date
SQL
2 votes283 views2 answers
How to check data type in sql server
SQL