How come code inside a false condition is causing an error?

I have the following code with a condition that is false (lets say 1=2.) 
How come I get an error that is related to the code inside if the condition 
is false?

Msg 927, Level 14, State 2, Line 3 Database 'NMS' cannot be opened. It is in 
the middle of a restore.



The code

IF 1= 2

begin

select * FROM NMS..MR_BackupHistory

end

The error in case it is executed when the db is being restored.

Msg 927, Level 14, State 2, Line 3 Database 'NMS' cannot be opened. It is in 
the middle of a restore.



Thanks Avi

Its failing to produce "compile" the plan.

You can use EXEC...


IF 1= 2

begin

    exec( 'select * FROM NMS..MR_BackupHistory' )

end


"Avi" <rememberoti@yahoo.com> wrote in message 
news:eXvdKlhjKHA.4500@TK2MSFTNGP06.phx.gbl...
> How come code inside a false condition is causing an error?
>
> I have the following code with a condition that is false (lets say 1=2.) 
> How come I get an error that is related to the code inside if the 
> condition is false?
>
> Msg 927, Level 14, State 2, Line 3 Database 'NMS' cannot be opened. It is 
> in the middle of a restore.
>
>
>
> The code
>
> IF 1= 2
>
> begin
>
> select * FROM NMS..MR_BackupHistory
>
> end
>
> The error in case it is executed when the db is being restored.
>
> Msg 927, Level 14, State 2, Line 3 Database 'NMS' cannot be opened. It is 
> in the middle of a restore.
>
>
>
> Thanks Avi
>
> 

It still has to parse all the text and create potential plans so it needs to 
see the stats for that table.

-- 

Andrew J. Kelly   SQL MVP
Solid Quality Mentors

"Avi" <rememberoti@yahoo.com> wrote in message 
news:eXvdKlhjKHA.4500@TK2MSFTNGP06.phx.gbl...
> How come code inside a false condition is causing an error?
>
> I have the following code with a condition that is false (lets say 1=2.) 
> How come I get an error that is related to the code inside if the 
> condition is false?
>
> Msg 927, Level 14, State 2, Line 3 Database 'NMS' cannot be opened. It is 
> in the middle of a restore.
>
>
>
> The code
>
> IF 1= 2
>
> begin
>
> select * FROM NMS..MR_BackupHistory
>
> end
>
> The error in case it is executed when the db is being restored.
>
> Msg 927, Level 14, State 2, Line 3 Database 'NMS' cannot be opened. It is 
> in the middle of a restore.
>
>
>
> Thanks Avi
>
>