Answer Posted / sanjeev kumar
It is a inbuilt function that delete the character starting
from second parameter and No of character as in 3rd
parameter and place the all character of 4th parameter in
place of them.
Example:-
SELECT STUFF('sanjeev', 2,3, 'kumar')
Results:-
skumareev
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between inner join and equi join?
What are the pre-defined functions in the sql server?
what is nonclustered index
Can you use order by when defining a view?
What is an expensive query?
Explain the difference between control flow and data flow?
What the difference between UNION and UNIONALL?
Can the query output be sorted by multiple columns in ms sql server?
Explain having clause and where clause?
What is the downside of using udf?
Explain the etl (extraction, transformation, and loading)?
What is trigger and different types of Triggers?
What is full outer join in sql server joins?
How to select all columns of all rows from a table with a select statement in ms sql server?
What are the different acid properties?