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

What is difference between rownum and rowid?

0 Answers  

---

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

---

What is the sql profiler?

0 Answers  

---

optimization techinques

0 Answers   Wipro,

---

What is data source in connection string?

0 Answers  

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

How many clustered indexes there can be on table ?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---