Answer / soorai ganesh

Try This.....

select replace('"ganesh"','"','''')

Output : 'ganesh'

Answer / vimal

Select Replace('""','""',Char(39)+Char(39))

Explain view in sql server?

0 Answers  

---

Different Types of Functions ?

2 Answers   Satyam,

---

Explain the different types of backups available in sql server? : sql server database administration

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

CREATE a table from another table

2 Answers  

---

---

What is the command to change the recovery model?

0 Answers  

---

What is the use of custom fields in report?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

How to list all user defined functions in the current database?

0 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

Explain transaction server explicit transaction?

0 Answers  

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---