Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's wrong with this statement?
Message
De
23/03/2005 08:35:06
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00997959
Message ID:
00998376
Vues:
38
Hello:

This your code:

update product set Name = 'RocheThomas RT14 Valve Oil', set ProductTypeID = 8 where SKU = 'AE1001'

This me code:

update product
set Name = 'RocheThomas RT14 Valve Oil',
ProductTypeID = 8
where SKU = 'AE1001'

you don't have to use SET's several.

Bye.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform