SqlServer 多表关联更新 删除 新增
更新语句一UPDATE A SET A.c2 =B.c3from A ,Bwhere A.c1=B.c1 更新语句二UPDATE ASET A.c2 =B.c3from A inner join B on A.c1=B.c1删除语句1、 delete from t1 where 条件2、delete t1 from t1 where 条件3、 delete t1 from t1,t2 where 条件4、delete t1,t2 from t1,t2 w…