how to replace double quotes by single quotes in sql server

Answer Posted / soorai ganesh

Try This.....

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

Output : 'ganesh'

Is This Answer Correct ?    21 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention a few common trace flags used with sql server?

520


Write a query to find 5th highest amount paid from the customer table.

514


Please differentiate between a local and a global temporary table?

538


Why I am getting this error when renaming a database in ms sql server?

515


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1311






What the different components in replication and what is their use?

496


What is abstracting periodical?

503


What is a cursor, index in sql?

545


What is sql view?

516


List few advantages of stored procedure.

517


What are triggers? How do you invoke a trigger on demand?

721


Does an index slow down updates on indexed columns?

561


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

588


Which trace flags are enabled in sql server?

505


How many categories of data types used by sql server?

574