SQL SERVER REPLICATE FORMULA

SQL SERVER REPLICATE FORMULA

-- THEORY

-- SELECT REPLICATE('VALUE ', [NUMBER OF TIMES TO REPLICATE VALUE]) AS [ALIAS NAME];

-- EXAMPLE

SELECT REPLICATE('TEST ',7) AS [DISPLAY REPLICATION OF THE WORD TEST 7 SEVEN TIMES];