Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update from inner SQL
Message
De
01/03/2011 21:52:54
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
01/03/2011 19:44:32
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01502274
Message ID:
01502321
Vues:
29
Why would it be safer?

>>I was curious so I tried this syntax on Postgres and it did not work as well. Personally, I like to see the table name as being updated. Updating an alias just seems wrong to me.
>
>I agree but when doing an extended Update syntax, which includes an INNER JOIN, I think it is safer to use the alias.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform