MSSQL SQL Server Update Delete table alias usage introduction

Transferred from: http://www.maomao365.com/?p=6973

Summary:
In SQL scripting, if you need to use the method of table aliases in update Delete, you must write according to certain rules, otherwise the corresponding exception information will appear as follows:
Lab environment: SQL Server R2

--How to-update table aliasesUpdate [aliases] Set [aliases].[Field] =[field Value]  from [Table name]  as [Table Aliases] where [conditions]--How to-delete table aliasesDelete [aliases] Set [aliases].[Field] =[field Value]  from [Table name]  as [Table Aliases] where [conditions] 

MSSQL SQL Server Update Delete table alias usage introduction