Update from inner SQL - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Update from inner SQL

Message

01/03/2011 19:00:17

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

01/03/2011 18:50:30

James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: Update from inner SQL

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01502274

Message ID:

01502303

Vues:

>I take all that back. This does not work.
>update ss set ss.siteCat = 1
>from site as ss join trans t
>on t.siteno = ss.siteno
>where ss.recno = 9000016

So, it seems SQL Server goes a little bit far more into support extra syntax, such as the one in my example. I got used to that. But, when trying the same SQL on that backend, it didn't. So, I guess that part was not fully SQL ANSI compliant. Is that also your findings?

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Répondre

Fil

Voir

Click here to load this message in the networking platform