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 2008 Forums
 Transact-SQL (2008)
 Limit of nested if else

Author  Topic 

Junior Sqler
Starting Member

18 Posts

Posted - 2013-03-28 : 11:36:20
Hello!

Is there a limit in the number of nested if else that can be used in sql server?







TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2013-03-28 : 11:42:31
from Books Online:
quote:

IF tests can be nested after another IF or following an ELSE. The limit to the number of nested levels depends on available memory.



Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -