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