SQL cte问题
create trigger ShanChu_Delete
on ShanChu for delete
as
declare @id int
select @id=id from deleted
;with cte as
(
select * from shanchu where type=@id
union all
select a.* from shanchu a join cte b on a.type=b.id
)
delete ShanChu where id in(select id from cte)
-------------------我需要在这里继续引用cte做更新操作
-------------------或者还有其他什么操作
-------------------请问有什么办法可以实现
go


[解决办法]