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

Can binary strings be used in arithmetical operations?

924

---

Does view occupy space?

933

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

999

---

What is the use of =,==,=== operators?

1001

---

What are the basic functions for master, msdb, model, tempdb databases?

1031

---

What is a rollup clause?

963

---

What is table-valued sub query?

955

---

What is tablix?

162

---

Explain filtered indexes?

988

---

How to check table values in sql server?

951

---

What is tabulation?

942

---

How to return the second 5 rows in ms sql server?

1051

---

What information is maintained within the msdb database?

968

---

Can I disable or restrict ssrs export formats (rendering formats)?

150

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

---