为什么我得到“服务器在编译时遇到堆栈溢出”错误是SQL server 2000 Sp4

试着优化你的和/或条件。

SELECT * FROM foo
WHERE ([fooKey] = 1 AND Year = 1995)
OR ([fooKey] = 1 AND Year = 1996)
OR ([fooKey] = 1 AND Year = 1997)
OR ([fooKey] = 1 AND Year = 1998)
OR ([fooKey] = 1 AND Year = 1999)
OR ([fooKey] = 1 AND Year = 2000)
OR ([fooKey] = 1 AND Year = 2001)
OR ([fooKey] = 1 AND Year = 2002)
... ad infinitum

变成

SELECT * FROM fooWHERE ([fooKey] = 1 AND Year between 1995 and 2002)
union
SELECT * FROM fooWHERE ([fooKey] = 10017 AND Year = 1995)
union
SELECT * FROM fooWHERE ([fooKey] = 10018 AND Year = 1997)
... slightly less

或者转到64位并尝试添加足够的内存以避免这种情况发生。..

有趣的bug!要问你的明显问题是, 为什么? 堆栈溢出是因为递归是解析这样的SQL语句的典型方式,它构建了一个语法树。根据每次递归调用推送到堆栈上的内容,这并不奇怪。服务器受伤了吗? ;)