Common functions in SQL Server replicate

Three REPLICATE of SQL common functions ()

Repeats a character expression by a specified number of times.

Grammar

REPLICATE (character_expression, integer_expression)


Parameters
character_expression
An alphanumeric expression of character data type, or an alphanumeric expression that can be implicitly converted to another data type of nvarchar or ntext.

Integer_expression
An expression that can be implicitly converted to int. If integer_expression is negative, an empty string is returned.

return value
nvarchar or ntext

1:select Replicate (' abc ', 2)----------------ABCABC

2:select Replicate (' abc ', -2)----------------null

3:select Replicate (' abc ', 0)---------------None

--Question: Why is the difference between 2 and 3 need research

Common functions in SQL Server replicate