Answer Posted / lipsa

Stuff is a Sql server function.It Deletes a specified
length of characters and inserts another set of characters
at a specified starting point.



SELECT STUFF('abcdef', 2, 3, 'ijklmn')
::will return te following result::

aijklmnef

How to verify a user name with sqlcmd tool?

577

---

What is database dimension? : sql server analysis services, ssas

612

---

how you can configure a running aggregate in SSRS?

112

---

How to use user defined functions in expressions?

543

---

How is SQL Azure different than SQL server?

91

---

---

Describe how to use the linked server?

589

---

What are the Advantages of using CTE in sql server?

564

---

What is lookup override?

580

---

Explain ranking functions?

601

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

622

---

Does group by or order by come first?

535

---

How do I completely remove sql server instance?

559

---

Do you know sql server 2008 backup compression?

562

---

What is update_statistics command?

572

---

what is normalization? : Sql server database administration

522

---