As most developers know, the SQL GO CMD signals the end of a batch of SQL statements.
However, another use of it, is to use it to execute a SQL statement multiple times. Just add a number after it. For instance:
SELECT GETDATE() as now GO 5
Which will execute the Select statement 5 times.
Or, something maybe more useful, create a table with integers from 1-5:
CREATE TABLE #numbers(number int) GO --> Execute the first batch INSERT INTO #numbers VALUES((SELECT COALESCE(MAX(number),0) FROM #numbers) +1) GO 5-->Do 5 times SELECT * FROM #numbers
Which will give you the result:
Batch execution completed 5 times. number ----------- 1 2 3 4 5 (5 row(s) affected)
Well, that was it. Another use of the go cmd. Have fun 🙂