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

Explain “not null constraint” in sql server?

958

---

Can sql servers link to other servers like oracle?

795

---

What are scheduled tasks in sql server?

1011

---

What is a virtual table in sql?

944

---

What is the bookmark lookup and rid lookup?

944

---

How to store and query spatial data?

937

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1079

---

How use inner join in sql server?

1059

---

What are the options which must be set to allow the usage of optimistic models?

917

---

How do database indexes work?

956

---

Explain transaction isolation levels in sql server?

1038

---

What is partition in sql server?

977

---

What are the new features of sql server 2012 reporting service?

123

---

What are “phantom rows”?

1609

---

What is spatial and temporal data?

933

---