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 you would rewrite the sql query to return the customerid sorted numerically?
Define cross join in sql server joins?
What is SQL Azure Fabric?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are the built in functions in sql server?
What is server-level principal?
How can I track the changes or identify the latest insert-update-delete from a table?
Explain in brief how sql server enhances scalability of the database system?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Can a function call a stored procedure in sql server?
What are the results of running this script?
What is the use of commit?
How to create a user to access a database in ms sql server using "create user" statements?
What are the two authentication modes in sql server?
What is data set in report?
