Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update from inner SQL
Message
From
01/03/2011 21:52:54
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
 
To
01/03/2011 19:44:32
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01502274
Message ID:
01502321
Views:
28
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform