[dba-SQLServer] TRIGGER question

It's not working for me. #deleted returns an "invalid object" error. I'm
using an INSTEAD trigger though, so maybe the #deleted table doesn't exist
for that kind of trigger? I could see where that might be the case. 

Susan H. 

Yes you're quite right, Michael. Should the update say "Update * FROM
Customers SET City = 'Los Angeles' WHERE City = 'New York'", then there
could be many rows in both #Inserted and #Deleted.