Tuesday, 10 May 2016

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

Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads


Post a Comment