How to replace double quotes by single quotes in sql server?

<<Previous   Next>>

Sql server   - How to replace double quotes by single quotes in sql server? - March 31, 2010 at 19:10 PM by Vidya Sagar

How to replace double quotes by single quotes in sql server? 

Using replace function, the double quotes can be replaced by single quotes. The following is an example:

Select replace('"Preetam"','"','''')
Result : 'Preetam' 

<<Previous   Next>>

SQL Server Database Objects

Table, Data types, Function, Index, Constraint, Rule, Default, Stored Procedures, Trigger, View..........

SQL server cursor

What is cursor in SQL Server?
Define the steps to use Transact-SQL Cursor.
Explain the cursor types.
Define the cursor lock types.
Explain in brief the cursor optimization tips.
Explain the disadvantages/limitation of the cursor.
Define scrollable cursor.
Temporary table VS Table variable: Cursor alternative............

BCP Utility and DTS Package

Describe in brief exporting and importing utility?, Describe how DTS is used to extract, transform and consolidate data................

SOAP support in SQL Server 2005

Explain the concepts and capabilities of SOAP. Explain the purpose of Native XML mode in SQL Server 2005.
Native XML Access vs. SQLXML.
Benefits of Native XML Access in SQL Server 2005.
Limitation for Native XML Web Services...............

 

Write your comment - Share Knowledge and Experience