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
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Will sql server 2005 allow you to reduce the size of a column?
How to store and query spatial data?
In what three ways is the return statement used in a stored procedure?
how many type of indexing in database?
Explain what are various ways to enhance the ssrs report?
What is the correct order of the logical query processing phases?
What's the information that can be stored inside a bit column?
What are triggers? How do you invoke a trigger on demand?
Why Master database is required?
Explain about Joins?
How many non clustered indexes there can be on table ?
Explain about Normalization?
What Is Rdbms?
Write a query for primary key constraint with identity key word?