更新时间:2023-02-02 22:42:00
检查 DELETE 语句文档,是,您可以使用 CTE 从中删除,它会影响基础表.同样对于 UPDATE 语句...
Checking the DELETE statement documentation, yes, you can use a CTE to delete from and it will affect the underlying table. Similarly for UPDATE statements...
如果我有一个临时表而不是 CTE,也是同样的情况吗?
Also is it the same case if I have a temp table instead of CTE?
不,从临时表中删除只会影响临时表——数据来自的表没有连接,临时表是一个独立的对象.
No, deletion from a temp table will affect the temp table only -- there's no connection to the table(s) the data came from, a temp table is a stand alone object.