Write a SQL command to repeat a string a specified number of time?

Question

Ashutosh Kumar Verma · Answer

The REPLICATE() function is used to print a string to specified number of time in SQL Server.
Syntax-and  REPLICATE(string, integer);
Example:
SELECT REPLICATE('MindStick.com ', 3);
Output:
and  and  MindStick.com MindStick.com MindStick.comand 
Also used to print any number in repeated number of given time.
SELECT REPLICATE(1456398784 , 3);
145639878414563987841456398784

interview

Write a SQL command to repeat a string a specified number of time?

Ashutosh Kumar Verma

Can you answer this question?

1 Answers

Liked By