Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IF BEGIN END confusion
Message
From
16/06/2008 09:42:48
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01324368
Message ID:
01324376
Views:
11
So, the BEGIN is almost like THEN? The lines before the BEGIN always exectute, but those inside the BEGIN only execute if the IF condition is true? If that is the case, then my IF condition must not be true for the behavior I'm seeing.

>When IF condition is true, the PRINT will be executed in both cases. OTOH, the BEGIN...END block will be executed always in the first case.
>
>
>>The PRINT statement executes:
>>
>>IF @Filename LIKE '%.tiff%'
>>
>>	PRINT @Filename
>>
>>	BEGIN
>>
>>		Some code here
>>
>>	END
>>
>>
>>The PRINT statement does NOT execute:
>>
>>IF @Filename LIKE '%.tiff%'
>>
>>	BEGIN
>>
>>		PRINT @Filename
>>		Some code here
>>
>>	END
>>
>>
>>Why?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform