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

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

What is subquery in sql?

0 Answers  

---

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

---

What is table constraint?

0 Answers  

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

What are binary string data types in ms sql server?

0 Answers  

---