Answer / abhaymalviya

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

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

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

What is a trace frag?

0 Answers  

---

What is the difference between varchar and varchar types?

0 Answers  

---

Explain acid?

0 Answers  

---

How do I edit a procedure in sql server?

0 Answers  

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---

What are the different acid properties?

0 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

What is SubQuery in SQL Server 2008

0 Answers   HCL,

---