Answer / soorai ganesh

Try This.....

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

Output : 'ganesh'

Answer / vimal

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

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

What is the difference between a unique key and primary key?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

How sql server executes a statement with nested subqueries?

0 Answers  

---

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

What is isolation levels?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

What is equi join with example?

0 Answers  

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---