Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Steve,
Try using brackets - [VALUE] instead of quotes.
>I am trying to insert records into a SQL Server 7.0 table where some of the text fields contain double and/or single quotes. I have searched the UT on this issue and found that the solution is to add an extra quote when one is found in the string, but this isn't working for me. When I add an extra quote, I get both quotes in my field.
>
>I have read the SET QUOTED_IDENTIFIER section in the BOL, but it is not completely clear. Does that setting only apply at the time the structure is created?
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