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


Please Help Members By Posting Answers For Below Questions

List the ways in which dynamic sql can be executed?

1094


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1031


How to provide default values to function parameters?

1272


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

1139


Explain system functions or built-in functions? What are different types of system functions?

1069


What are wait types?

1260


what is the difference between openrowset and openquery?

1207


Why and when do stored procedure recompile?

1075


How to convert character strings into numeric values?

1196


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1209


What is a view in sql?

1046


do you know how to configure db2 side of the application? : Sql server database administration

1132


How raid can influence database performance?

1127


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1081


Can we shrink data file in sql server?

1135