That's exactly what it does. YOU decide where to put the GOTOs
DECLARE @Counter int;
SET @Counter = 1;
WHILE @Counter < 10
SET @Counter = @Counter + 1
IF @Counter = 4 GOTO Branch_One --Jumps to the first branch.
IF @Counter = 5 GOTO Branch_Two --This will never execute.
SELECT 'Jumping To Branch One.'
GOTO The_End; --This will prevent Branch_Two from executing.
SELECT 'Jumping To Branch Two.'