Wednesday, July 10, 2019

C# and SQL and Dynamics GP: Sending a List to a Stored Procedure

By Steve Endow

This is a discussion of how to send a list of values to a SQL stored procedure parameter.

Specifically, how can a .NET application send a comma delimited list of values to a stored procedure to be used in an "IN" operator in a WHERE clause.

Using a parameter with a WHERE clause IN operator

TL;DR: If you want to jump straight to the solution, read this excellent post on Arrays and Lists in SQL Server by legendary SQL Server MVP Erland Sommarskog.

If you crave to learn about all of the exciting details, read on...

C# and SQL and Dynamics GP: Sending a List to a Stored Procedure

By Steve Endow This is a discussion of how to send a list of values to a SQL stored procedure parameter. Specifically, how can a .NET ap...