Multiple choice technology databases

Which is not parameters for STUFF function

  1. First string

  2. Second string

  3. Start position

  4. End position
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The STUFF function in SQL Server uses four parameters: the source string (first string), start position (where deletion begins), length (number of characters to delete), and the replacement string (second string). There is no 'end position' parameter - the function uses length instead to determine how many characters to remove before inserting the replacement string.

Keep practicing — related questions