Answer / anjana

Table test have one column as name:

Test
name
a
b
c
d
e
f
g

select replace(name,'e','f') from test order by name


Output will be:

a
b
c
d
f
f
g

what is Full Text Search ?

1 Answers   TCS,

---

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

how to take backup bcp out for a column in table in sql server?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

---

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

What is row by row processing ?

2 Answers  

---

What is nolock?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---