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
How do you rebuild an identity column?
What is pessimistic concurrency?
Explain system functions or built-in functions? What are different types of system functions?
how many type of indexing in database?
Can you force a query to use a specific index?
What happens on checkpoint?
Explain what role entity and relationship play in an ER diagram.
What is coalesce and check constraint in sql server?
Explain linked server in sql?
What is the difference between index seek vs. Index scan?
What are the advantages of passing name-value pairs as parameters?
How many triggers you can have on a table?
Can you insert NULL in unique column?
Does partitioning ssd reduce performance?
what are different types of raid configurations? : Sql server database administration