0

I want to call a stored procedure from a Web Api controller. As a parameter i need to pass id's of items to the sp but id count is not stable. For a case i may pass 3 ids for another it may be 10 ids. Is it possible to pass an array or list of numbers to a stored procedure.

Berat Burak Tetik
  • 1

1 Answers1

0

Use a Table-Valued Parameter, JSON, or XML.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67