Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / write a sql command to repeat a string a specified number of time?
Ask Question
Ashutosh Kumar Verma
Ashutosh Kumar Verma

Jr software developer trainee

Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.

Message

1 Answers

Ashutosh Kumar Verma
Ashutosh Kumar Verma 15 Nov 2021
Report Abuse

The REPLICATE() function is used to print a string to specified number of time in SQL Server.

Syntax-  REPLICATE(string, integer);

Example:

SELECT REPLICATE('MindStick.com ', 3);

Output:

    MindStick.com MindStick.com MindStick.com 
Also used to print any number in repeated number of given time.

SELECT REPLICATE(1456398784 , 3);

145639878414563987841456398784

MindStick Training