interview

home / developersection / interviews / what is stuff() function is sql server?

Ask Question
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.

Follow
Can you answer this question?
Answer

1 Answers

Ashutosh Kumar Verma

Ashutosh Kumar Verma

11-Nov-2021

STUFF() in SQL:

 STUFF() function is used to delete a part of given string and insert a new string at that positon.

Syntax- STUFF(string, start, length, new_string);l

Example-


MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy