Answer / 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

Answer / 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

How to get the definition of a stored procedure back?

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

Explain the dirty pages?

0 Answers  

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

What is the distinction amongst delete and truncate?

0 Answers  

---

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---

Why is normalisation important?

0 Answers  

---

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---