Limit on the WHERE col IN (…) condition

by

Depending on the database engine you are using, there can be limits on the length of an instruction.

SQL Server has a very large limit:

http://msdn.microsoft.com/en-us/library/ms143432.aspx

ORACLE has a very easy to reach limit on the other side.

So, for large IN clauses, it’s better to create a temp table, insert the values and do a JOIN. It works faster also.

More Related Contents:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. How to calculate age (in years) based on Date of Birth and getDate()
  3. CROSS JOIN vs INNER JOIN in SQL
  4. Convert Month Number to Month Name Function in SQL
  5. Function vs. Stored Procedure in SQL Server
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  8. Generate Dates between date ranges
  9. Select group of rows that match all items in a list
  10. SQL Server check case-sensitivity?
  11. How to print VARCHAR(MAX) using Print Statement?
  12. How to update Identity Column in SQL Server?
  13. How to assign an exec result to a sql variable?
  14. Concatenate values based on ID
  15. Query error with ambiguous column name in SQL
  16. Why (and how) to split column using master..spt_values?
  17. Splitting delimited values in a SQL column into multiple rows
  18. What does =* mean?
  19. SQL: parse the first, middle and last name from a fullname field
  20. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  21. SQL Select Upcoming Birthdays
  22. How can I include null values in a MIN or MAX?
  23. Get Start and End Date from Week Number SQL Server
  24. How to get the identity of an inserted row?
  25. Get the last day of the month in SQL
  26. TSQL – How to use GO inside of a BEGIN .. END block?
  27. SQL take just the numeric values from a varchar
  28. MAX vs Top 1 – which is better?
  29. How to get Previous Value for Null Values
  30. CONCAT_WS() for SQL Server

Leave a Comment