If Else Strangeness

Question

If Else Strangeness

staples.benjamin

Newbie

Points: 2
More actions
October 27, 2009 at 5:54 am

#142722

Why is this sql generating an error? The reg table has several columns, but it should never get there? I guess it executes the sql anyway? Is there another way to do this? I tried searching for this but it's a little hard to find this problem. Thanks in advance for your help.
if 1=0
begin
insert into reg values(0)
end

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HowardW One Orange Chip Points: 29109 More actions · Answer 1

The SQL is parsed before it evaluates the conditions of the IF statement, so you'll need to use dynamic SQL for this, which won't be evaluated until the statement is executed. E.g.:

if 1=0

begin

declare @sql varchar(8000)

set @sql='insert into reg values(0)'

exec (@sql)

end

staples.benjamin Newbie Points: 2 More actions · Answer 2

I was afraid I'd have to do that. Thanks for the quick reply.

Mike01 SSChampion Points: 11395 More actions · Answer 3

why wouldn't you just comment this code out or remove it altogether?

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/