Code to repliacte the same string several times

Virendradugar
Posted by Virendradugar under Sql Server category on | Views : 1302
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

Comments or Responses

Login to post response