problem in insert data in sql server

Question

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

Sam Hobbs · Answer

Use parameters in your insert command.

Deepak Bhatia · Answer

Hi Vipin When you are inserting before inserting the value replace the single quote ' with '' double quote.

Mamta M · Answer

Use the single quote ' as a escape character.