This blog shows how to repeat a string N number of times using REPLICATE in SQL Server
Syntax:
REPLICATE ( characterexpression ,integerValue )
Example:
SELECT REPLICATE ('A', 5)
The expected result would be like AAAAA
SQL Server Transact Basic to Expert - Repeating a string N number of times
SQL Server Transact Basic to Expert - Repeating a string N number of times
Join the conversation! Your thoughts help the community grow.