how to replace double quotes by single quotes in sql server

Answer Posted / vimal

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

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the report builder?

119


What is the order by used for?

792


How to call a function from a stored procedure in SQL Server ?

737


What happens if date-only values are provided as date and time literals?

746


What are the advantages of passing name-value pairs as parameters?

831






What is sql server programming?

759


What is data set in report?

112


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

691


What is the difference between deallocate cursor and close cursor?

912


explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

662


What are the steps to take to improve performance of a poor performing query? : sql server database administration

784


What are sql dirty pages?

756


How can you know if the row fetched from cursor is still valid in underlying table?

756


What is 3nf normalization?

733


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

694