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
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
Comments