Geek Answers Handbook

Is there a limit on the duration of a SQL query in SQL Server?

Possible duplicate:
Maximum size for SQL Server Query? IN? Is there a better approach

I searched Google for a while and cannot find out if there is some hard limit on how huge query strings can be in SQL Server. I mean, if I create a request for 100 million characters - will it start or will the server just drop it for too long?

Is there a limit on the duration of a SQL query (in terms of characters or tokens or something similar) in SQL Server?

+7
source share
1 answer

I have never encountered the problem of too many SQL queries regarding the number of characters, but there is a maximum number of tables , the query can reference (256), and I hit this restriction several times.

Have you ever come across a query that SQL Server could not execute because it referenced too many tables?

+11
source

More articles:


All Articles