Sql Stored Procedure with parameter that include single quote -FAIL

  • 5 August 2020
  • 0 replies
  • 0 views

Badge

Hello all,

I try to insert data into sql server table by calling sql stored procedure with parameters. 

my problem is that when one of the parameters include single quote i got exception. and the process fail.

Here is an example  of how i call the stoerd procedure:

 

EXEC [dbo].[spInsertIECMazkirotPermissionForm]
{ItemProperty:ID}
,'{ItemProperty:City}'
,'{ItemProperty:Street}'

 

if Street value is  AB'C  for example it fail.

*  I have to use ItemProperty


0 replies

Be the first to reply!

Reply