How can I put an alias on the table in an Update query
Update T64PE as Person
Where Person.ID = 5
(PS This works with Sybase)OK
Found this !
Update T64PE
Set NAME='CHIRAC'
From T64PE as Person
Where Person.ID = 5|||Originally posted by Karolyn
OK
Found this !
Update T64PE
Set NAME='CHIRAC'
From T64PE as Person
Where Person.ID = 5
Even more :
Update Person
Set NAME='CHIRAC'
From T64PE as Person
Where Person.ID = 5|||noted !
(thks)sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment