SQL Server provides a function called "REPLICATE()", which replicates the passed string.
SELECT REPLICATE('Virendra Dugar ',10) This code will replicate the string 10 times.
Result: Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar Virendra Dugar
Thanks,
Virendra Dugar