REPLICATE (Transact-SQL) - SQL Server | Microsoft Learn
Nov 18, 2025 · If string_expression input is not of type varchar (max) or nvarchar (max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, …
SQL Server REPLICATE () Function - W3Schools
Definition and Usage The REPLICATE () function repeats a string a specified number of times. Syntax REPLICATE (string, integer)
SQL Server REPLICATE () Function By Practical Examples
In this tutorial, you will learn how to use the SQL Server REPLICATE () function to replicate a string a specified number of times.
SQL REPLICATE Function Use and Examples - SQL Server Tips
Apr 27, 2025 · Learn how to use the SQL Server REPLICATE function to replicate a string X number of times along with examples of use.
SQL REPLICATE () String Function - Syntax, Examples [4]
With this setup complete, you can run the REPLICATE() function examples to test and view results in the users table. We’ll go through examples demonstrating the REPLICATE() function in SQL, using …
SQL Server REPLICATE () Function
In some cases, using the REPLICATE() function can help us process and analyze data more conveniently. The REPLICATE () function is used to repeat a string a certain number of times to …
SQL REPLICATE Function - Tutorial Gateway
The SQL Server REPLICATE is a String Function used to repeat the existing string for a given number of times. This replicate function accepts both character string or binary data and returns the same …
REPLICATE Function of SQL Server
Nov 29, 2023 · In this SQL Server tutorial, you will learn how to use the REPLICATE function in SQL Server. You will learn where to use the REPLICATE () function with syntax and its definition.
REPLICATE () Function in SQL Server - GeeksforGeeks
Dec 30, 2020 · REPLICATE () function : This function in SQL Server is used to repeat the specified string for a given number of times. Features : This function is used to return the stated string for a …
How the REPLICATE () Function Works in SQL Server (T-SQL)
May 16, 2019 · In SQL Server, the T-SQL REPLICATE() function repeats a string value a specified number of times and returns the result. The function accepts two arguments; the input string, and the …