adspace
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
List the ways in which dynamic sql can be executed?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to provide default values to function parameters?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain system functions or built-in functions? What are different types of system functions?
What are wait types?
what is the difference between openrowset and openquery?
Why and when do stored procedure recompile?
How to convert character strings into numeric values?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is a view in sql?
do you know how to configure db2 side of the application? : Sql server database administration
How raid can influence database performance?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Can we shrink data file in sql server?