Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to replace double quotes by single quotes in sql server

Answers were Sorted based on User's Feedback



how to replace double quotes by single quotes in sql server..

Answer / soorai ganesh

Try This.....

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

Output : 'ganesh'

Is This Answer Correct ?    21 Yes 1 No

how to replace double quotes by single quotes in sql server..

Answer / vimal

Select Replace('""','""',Char(39)+Char(39))

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Define right outer join in sql server joins?

0 Answers  


What is a transaction and what are ACID properties?

3 Answers  


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,


What is compound operators?

0 Answers  


What is the maximum row of a size?

0 Answers  


What are the dmvs? : sql server database administration

0 Answers  


How to count duplicated values in a column in ms sql server?

0 Answers  


Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,


What is dirty page?

0 Answers  


i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,


What command is used to delete a table from the database in the sql server and how?

0 Answers  


Categories