CHRTRAN() is much faster than STRTRAN().
Vlad
>You have two solution available to you. The first is to convert the single single-quote to two single quotes. SQL Server sees this as a literal single quote. You ought to be able to use STRTRAN() to do the convertion:
>
>lcDiary = STRTRAN(lcDiary, "'", "''")
>
>The second solution involves issuing the SET QUOTED_IDENTIFIER OFF. This will allow SQL Server to receive strings that are delimited by either a single or double quote.
>
>-Mike
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement