Answer / soorai ganesh

Try This.....

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

Output : 'ganesh'

Answer / vimal

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

Can XML be used to access data?

2 Answers  

---

What security features are available for stored procedure?

0 Answers  

---

What stored by the msdb? : sql server database administration

0 Answers  

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

What is log cache in sql server?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

Will count(column) include columns with null values in its count?

0 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

How to receive output values from stored procedures?

0 Answers  

---

What is user defined stored procedures?

0 Answers  

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---