Answer / soorai ganesh

Try This.....

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

Output : 'ganesh'

Answer / vimal

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

What is difference between createstatement and preparedstatement?

0 Answers  

---

What is isnull() operator?

0 Answers  

---

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

---

What is for xml in sql server?

0 Answers  

---

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

0 Answers  

---

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

what is a mixed extent? : Sql server administration

0 Answers  

---

Define tempdb database?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

Explain magic tables in sql server?

0 Answers  

---

What is difference between delete & truncate commands?

0 Answers  

---