Is there any limitation in SQL server IN clause?

Question

 

I know there is limitation in ORACLE database IN clause, only 1000 expression supported.

Select * from TABLE where ID in (1,2,...1000)

 

Is there any limitation in SQL server IN clause?

 

Answer 1

There is no limitation in SQL Server w.r.t in caluse. you can give n number of values

 

Answer 2

I dont know limitation number but i had problem yesterday with in clause.Same query work with little then subquery data. But not return resultset with big subquery data. In same query i changed IN CLAUSE to EXISTS and my problem solved.I'll never use IN clause with big subquery data.