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

Write the syntax for stuff function in an sql server?

0 Answers  

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

What stored by the master?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

---

How can a database be repaired?

0 Answers  

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

what is a check constraint?

0 Answers  

---

List the different types of joins?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

Explain about Normalization?

0 Answers   Infosys,

---

can any one please send sql quries most used in applications.

2 Answers  

---