Answer Posted / 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

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

916

---

What is the process of normalization?

1058

---

Where in ms sql server is ’100’ equal to ‘0’?

1021

---

What sql server means?

910

---

How many null values we can have in a unique key field in sql server?

905

---

How do I perform an unattended install of sql server 2000?

1020

---

Explain about remote stored procedure?

966

---

How to populate a table in sql server?

894

---

Define synonym?

1118

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

853

---

what exactly sql injuction.how to overcome.....

2485

---

How to use the inserted and deleted pseudo tables?

916

---

How many types of the database links?

1025

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

999

---

What are the different types of sub-queries?

997

---