loai
Novice

Sql Stored Procedure with parameter that include single quote -FAIL

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 Kudos
Reply