Answer / soorai ganesh

Try This.....

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

Output : 'ganesh'

Answer / vimal

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

How does normalization work?

1 Answers  

---

What is transact-sql ddl trigger?

1 Answers  

---

What are key constraints?

1 Answers  

---

Which sql server table is used to hold the stored procedure script?

1 Answers  

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1 Answers  

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1 Answers   HCL,

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

Explain the etl (extraction, transformation, and loading)?

1 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---