How to Insert Same Records Multiple Time in SQL Server Without Using any While Loop

Write a query to insert your name 1000 times without Using While Loop in SQL Server?

Ans: I will use Go statement post-fix with no of record want to insert, it will implement internal loop, So that we does not need to write While loop query.

You can see below I have inserted 1000 records without While keyword



Contact Form