Answer Posted / ruchi

STUFF - Delete a specified length of characters and insert
another set of characters at a specified starting point.
For example: SELECT STUFF('asdfghjkl', 3, 5, 'XYZ')
Go
here the result set is:

asXYZkl

REPLACE - Replace all occurrences of the second given string
expression in the first string expression with a third
expression.
For Example: SELECT REPLACE('Abhay', 'a', 'KKT')
Here the result set is:

KKTbhKKTy

What does normalization do to data?

993

---

How you trouble shoot when any job fails

1896

---

How many joins in sql server?

901

---

Explain in details security in SQL azure?

121

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1833

---

Explain syntax for viewing, dropping and disabling triggers?

899

---

What are rest-style architecture's?

170

---

What is checkpoint in sql server?

1062

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

902

---

Find first and last day of current month in sql server

978

---

What is extent? Types of extents?

1089

---

How do I find sql server instance name?

917

---

What is the difference between functions and stored procedures?

1093

---

What is snapshot parameter in ssrs?

140

---

How to create a dml trigger using create trigger statements?

977

---