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
Tell me what is sql profiler?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is page in sql server?
What new changes are being made in SQL Server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Differentiate between mongodb vs. Sql server?
What are the differences between stored procedure and the dynamic sql?
What are xml indexes?
What is a Join and explain its types?
Can you explain different types of joins?
What is the synonym of join?
What are wait types?
How to convert a table data in XML format in sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Tell me what is difference between view and materialized view?