Go and While Statements - T-SQL Step by Step Course - Lesson 34 | SQL courses

Duration: 16:22 min

Summary: In this video, we will talk about the ‘go’ and ‘while’ statements. We have used the go statements with batches in the previous lesson, but today, we will see how to use ‘go’ with a number to execute a statements that many times. In addition, we will explore the ‘while’ statements. Normally, you should avoid using loops like that because it does not line well with set based statements. But it has its benefits when you need to iterate over the records one at a time. We will look at some examples, and see how to use the ‘break’ and ‘continue’ statements within while as well.