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

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

What is the size of transaction log file?

0 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

What is Cross Join

3 Answers  

---

Define self join in sql server joins?

0 Answers  

---

Explain active/passive and active/active cluster configurations?

0 Answers  

---

How to insert multiple rows with a subquery?

0 Answers  

---

Find columns used in stored procedure?

0 Answers  

---

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

---

What is an index in sql?

0 Answers  

---