Repeat Specific Character or Word in SQL Server 2012 without Loop

Replicate string function of SQL Server repeats a character or string values for the specified number of time.
Example 1:
  1. Select Replicate('T',5) 
Output

TTTTT

Example 2:
  1. Select Replicate('Jignesh ',3) 
Output:

Jignesh Jignesh Jignesh