SQL Server: Dynamic where-clause

by

You have two options. If you’re using SQL Server 2008 (or Oracle) you can pass in a table value parameter.

If you’re using SQL Server 2005, you can use XML to simulate this capability

If you’re using something earlier than 2005, you need to concatenate the ids in a single string and create a UDF to parse them.

More Related Contents:

  1. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  2. Any way to SQLBulkCopy “insert or update if exists”?
  3. Pros and Cons of using SqlCommand Prepare in C#?
  4. Is it better to execute many sql commands with one connection, or reconnect every time?
  5. Where is likely the performance bug here? [closed]
  6. C# Sql Textbox Select
  7. Best way to reverse a string
  8. How to execute a stored procedure within C# program
  9. Implementing a log viewer with WPF
  10. How to get object size in memory? [duplicate]
  11. Must declare scalar variable @Id?
  12. Debug vs. Release performance
  13. Save byte[] into a SQL Server database from C#
  14. LINQ: Not Any vs All Don’t
  15. Getting return value from stored procedure in C#
  16. String interning in .Net Framework – What are the benefits and when to use interning
  17. Using lambda expressions for event handlers
  18. Is there any difference between DateTime in c# and DateTime in SQL server?
  19. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  20. C# vs C – Big performance difference
  21. Fastest function to generate Excel column letters in C#
  22. Multi threading C# application with SQL Server database calls
  23. What SqlDbType maps to varBinary(max)?
  24. Received an invalid column length from the bcp client for colid 6
  25. How to pass XML from C# to a stored procedure in SQL Server 2008?
  26. How can I convert ticks to a date format?
  27. Check if property has attribute
  28. Does the order of LINQ functions matter?
  29. Why is processing a sorted array slower than an unsorted array?
  30. HTTPWebResponse + StreamReader Very Slow

Leave a Comment