problem in insert data in sql server
I am using simple insert command for insert data in sql server in which data field is nvarchar(max) but when i insert text with special charcter as ; or ' or " its give error please help me
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sam HobbsPosted Aug 2, 2010, 1:47 PM
Deepak BhatiaPosted Aug 2, 2010, 6:31 AM
When you are inserting before inserting the value replace the single quote ' with '' double quote.
Mamta MPosted Aug 2, 2010, 6:10 AM