Is there a limit to the number of conditions I can put in the WHERE clause of a SELECT statement?
I am recieveing a list of values (UIDS actually) and I need to dynamically create a SQL Statement. My only concern is if there is a limit to the number of conditions 'OR' in the Statement, the list could be anywhere from 1-1000+ values. Is it safe to construct the statement this large? Or I do I need to run individual queries, or batches with a max number. Any advise on the optimal way to do this would be appreciated.