Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RE : Ms-Sql2000....field check
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00661884
Message ID:
00661943
Vues:
19
Sarp,

The standard string delimiter in Sql Server is a single quote. The double quote can or cannot be used based on the SET QUOTED_IDENTIFIER setting. See BOL for details. I would recomend always use a single quote. You've to double it in the string as shown below.
EXECUTE ('update mal set ' + @xdepo + ' = ' + @xmiktar + 
  ' where malno = ''' + @xmalno + '''')
To get faster and better answers:
- Give your posts proper title. I don't see what your message has to do with 'field check'.
- The 'RE:' prefix is used to indicate a reply.
- Use < pre > tag to make your code more readable in the message.

< snip >
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform