SQL SERVER – Repeate String N Times Using String Function REPLICATE

I came across this SQL String Function few days ago while searching for Database Replication. This is T-SQL Function and it repeats the string/character expression N number of times specified in the function.

SELECT REPLICATE( ' http://dlprwt.blogspot.in/ ' , 9 )

This repeats the string http://dlprwt.blogspot.in/ to 9 times in result window. I think it is fun utility to generate repeated text if ever required.

Result Set:
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/
http://dlprwt.blogspot.in/