Friday, 22 April 2016

Use of REPLICATE function in SQL server ?

REPLICATE function is used to repeat the sting value a specified no of times
Syntax:
REPLICATE(STRING EXPRESSION,INT EXPRESSION)

Example:
SELECT REPLICATE('SQL',5)

Output:
SQLSQLSQLSQLSQL

No comments:

Post a Comment