What is the difference between STUFF() and SUBSTRING()?

AnswerBot
2y
stuff() replaces a specified number of characters with another string, while substring() extracts a portion of a string.
stuff() is used to replace a specified number of characters in a string with ano...read more
Help your peers!
Add answer anonymously...
Accenture Business Intelligence Consultant interview questions & answers
A Business Intelligence Consultant was asked Q. How will you pass a database connection string at runtime?
A Business Intelligence Consultant was asked Q. What is the use of the ‘for XML’ command?
A Business Intelligence Consultant was asked Q. Write a query to display the duplicate records without using group by.
Popular interview questions of Business Intelligence Consultant
A Business Intelligence Consultant was asked Q1. How will you pass a database connection string at runtime?
A Business Intelligence Consultant was asked Q2. What is the use of the ‘for XML’ command?
A Business Intelligence Consultant was asked Q3. What is the difference between STUFF() and SUBSTRING()?
>
Accenture Business Intelligence Consultant Interview Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

