在 SQL Server 中使用 delete 和 update的
inner join 。
而SQL Server中须写为:
delete from t1 from t1 inner join t2 on t1.id = t2.tid
update t1 set t1.name='Liu'
from t1 inner join t2 on t1.id = t2.tid
insert table (filed1)
select name from userinfo