Code Snippet posted by:
Virendradugar | Posted on: 1/25/2010 | Category:
SQL Server Codes | Views: 685 | Status:
[Member] [MVP]
|
Alert Moderator
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