SQL Server中Delete语句表名不能用别名
delete from TABLEA A where A.FIELD1=10 (ORACLE适用)
delete TABLEA from TABLEA A where A.FIELD1=10 (SQLSERVER适用)
delete from TABLEA where TABLEA.FIELD1=10 (Ora/SQL均适用)
posted on 2015-12-21 12:48 nickTimer 阅读(1013) 评论(0) 编辑 收藏 举报