Developing Portable Applications : 2. Achieving Transparency and Portability : DBMS Limitations with Derived Tables : Deeply Nested Selects Limited in Microsoft SQL
 
Share this page                  
Deeply Nested Selects Limited in Microsoft SQL
The gateway can handle deeply nested selects, but Microsoft SQL Server has an undocumented restriction on how deep selects can be nested. Testing of Microsoft SQL Server has revealed that only up to 48 nested selects work. If more than 48 selects are nested, SQL Server will generate an error saying that the query is nested too deeply.