Posted on: 5/5/2011 3:07:37 AM | Views : 264

Hai all,
Whenever I try the below code in Sql Server 2005  control will go to both lables,eventhough the if condition fails .why is it so?Please help me in this regard.
Thanks in advance
DECLARE @C int DECLARE @c1   int SET @c=1 SET @c1=2
       IF @c= 3 begin
    GOTO Branch_One    
end
IF @c1=4
begin
goto Branch_Two
end
Branch_One:                     print 'Jumping To Branch One.' Go to the complete details ...