Mahmoud ElMansy: knowledge meant to be free

SQL Server – REPLICATE function (repeat string N numbers of times)

REPLICATE function this is one of the sql server string functions.
This function repeat string or char N number of time

REPLICATE ( string_expression ,integer_expression )

Example.

DECLARE @st VARCHAR(10)='@1';
SELECT Replicate(@st,4)

The result.

@1@1@1@1