Working with GoTo block in Sql Server.

Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 456
GoTo block in Sql Server is same as GoTo block in C#. It means it jumps to to defined block.In our code,if @rec_cnt variable value is greater than 0,then it jumps to the exit block.
and inside exit block,it will print value,We have to define GoTo keyword followed by name or label name and we have to give colon(:) in GoTo name block.

Declare @rec_cnt Int;
Select @rec_cnt = Count(*) From Employee_Master Where Employee_Id = 1;

If(@rec_cnt > 0) GoTo ExitBlock
GoTo Steps
Print 'ExitBlock';

You can give your own condition for GoTo Statement.

Comments or Responses

Login to post response