Passing a SQL parameter to an IN() clause using typed datasets in .NET
You can’t use a single parameter for a list of values in this way. But there may be database-specific ways to achieve what you want. For example, with SQL Server 2005 or later you could create a table-valued function to split your string parameter, something like: CREATE FUNCTION dbo.F_Split ( @InputString VARCHAR(MAX) ,@Separator VARCHAR(MAX) ) … Read more