Insert single quotation mark in SQL Server database

pp1234

SOLVED CLOSED ACTIVE ANSWERED
User: pp1234
Posted: on Dec 18, 2013 01:53 AM
Forum: SQL Server
Answer: 1
Views: 2344

hi,i have one online examination application,in that am inserting questions into database table by uploading questions and answers from excel sheet.Am getting error as incorrect syntax near 'a' while am inserting questions into database,means in the question column i want to insert question,if question column have 'a' it is not inserting into database,the datatype for question column is ntext....please help me.....

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Dec 18, 2013 01:53 AM
Report

You will have to replace single quote with " which is the HTML Code for single quote

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Insert single quotation mark in SQL Server database

Company

Explore

Follow us

Contact Us