(特殊的)增删改查

插入数据

declare @vid int
select @vid=max(id)+1 from Table_1
insert into Table_1
select @vid,b.name
from Table_1  a inner join Table_2 b on  a.id=b.id
where b.id=1 and b.name='加下划线为阿斯达司法所'

另一种删除数据的方法(MSDN上没有)

insert into Table_1 values(1,'加下划线为')
insert into Table_2 values(1,'加下划线为阿斯达司法所')
表关联删除
select * from Table_1

select * from Table_2

delete a  from Table_2 a inner join Table_1 b on  a.id=b.id where b.id=1 and b.name='加下划线为'

原文地址:https://www.cnblogs.com/rongxiaoya/p/3065238.html