Anhgolden's Blog!
Sổ tay tin học...
Pages
Home
Contact Me
Excel
SQL
SugarCRM
Search
Thursday, October 26, 2017
Using Alias in Update SQL Statement
(
Anhgolden's Blog
) - Example
Without Alias:
==//==
Update tableA
Set name='abc'
==//==
With Alias statement:
Update A
Set A.name='abc'
From tableA as A
Update A
Set A.name=B.name
From tableA as A, tableB as B
Where A.id=B.id
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment