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




WHAT OTHERS ARE READING/RELATED TO THIS:

0 comments:

Post a Comment

Find job here...