Maximum amount of items in CSV for SELECT WHERE IN

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Maximum amount of items in CSV for SELECT WHERE IN

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-14 : 00:03:38

Phil writes "I am trying to determine if T-SQL has a maximum amount of items permissible within a CSV for a SELECT WHERE IN

e.g. select stuff from stuff_table
where stuff_id in (1, 2, ..., 1000) <-- how big can this get?

Thanx
Phil"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources