dot Net Database Question:

Explain What is the STUFF function and how does it differ from the REPLACE function?

dot Net Database Interview Question
dot Net Database Interview Question

Answer:

STUFF - It deletes a specified length of characters and inserts another set of characters at a specified starting point. REPLACE -Replaces all occurrences of a specified string value with another string value.


Previous QuestionNext Question
Explain What are cursors? Name four type of cursors and when each one would be applied?Explain the use of trace utility?