转、SqlServer中delete语句表别名的问题

转自https://www.cnblogs.com/willingtolove/p/9398114.html

1、一般情况下删除表数据的sql语句：

delete from products
where rowid>2

 

2、如果想给表起个别名再删除呢，就得像下面这样写了

delete products from products as p
where p.rowid>2

也可这样

delete p from products as p
where p.rowid>6

delete srsfkw01 from srsfkw01 a left JOIN BIXNDW c
ON c.BIXNDW_DWID =data_DWID
where BIXNDW_DWID is null;

 

主要是 不能直接 delete from products p

得变成 delete products from products p

ORACLE 可以直接起别名   　

delete from products p
where p.rowid>2