Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update from inner SQL
Message
From
01/03/2011 19:00:17
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
01/03/2011 18:50:30
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Update from inner SQL
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01502274
Message ID:
01502303
Views:
24
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform