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 the steps needed to create a scheduled job?

0 Answers  

---

What is the default value of CHAR type?

10 Answers   Bosch,

---

Describe and explain about SQL native client?

0 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

How to drop existing indexes in ms sql server?

0 Answers  

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---

What is trace flag in sql server?

0 Answers  

---

Explain the disadvantages of cursors?

0 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

What are the dis_advantages of stored procedures, triggers, indexes?

0 Answers  

---