Answer / soorai ganesh

Try This.....

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

Output : 'ganesh'

Answer / vimal

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

what is Covering Index ?

3 Answers   Thomson Reuters,

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

What is sql server profiler?

0 Answers  

---

Can you explain important index characteristics?

0 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

Explain transaction server implicit?

0 Answers  

---

What is difference between oltp and olap?

0 Answers  

---

How can sql server instances be hidden?

0 Answers  

---

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

What is sql server transaction log file?

0 Answers  

---