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

Does sql server 2000 clustering support load balancing?

960

---

What are parameterized reports? What are cascading parameters in ssrs reports?

156

---

Explain how you can configure a running aggregate in SSRS?

163

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

992

---

What is the use of partition by in sql server?

927

---

what is a transaction and what are acid properties? : Sql server database administration

1018

---

What are the different types of columns types constraints in the sql server?

1076

---

What is db stored procedure?

876

---

Difference between DELETE and TRUNCATE?

1045

---

Tell me what is the significance of null value and why should we avoid permitting null values?

976

---

What is difference between views and stored procedures?

982

---

What is ms sql server triggers?

1001

---

Explain foreign key in sql server?

1015

---

How to find out the list schema name and table name for the database?

933

---

How to create a simple user defined function in ms sql server?

1008

---