批量更新主要运用于表t1需要依赖于表2来进行某个字段的更新,例如根据User表将Student表的UserName字段更新一致:
update [Student] set UserName=t2.UserName from [Student] t1,[User] t2 where t1.id=t2.id
写法:
update t1 set t1的字段= t2的字段 from t1, t2 where t1.Id = t2.Id
批量更新主要运用于表t1需要依赖于表2来进行某个字段的更新,例如根据User表将Student表的UserName字段更新一致:
update [Student] set UserName=t2.UserName from [Student] t1,[User] t2 where t1.id=t2.id
写法:
update t1 set t1的字段= t2的字段 from t1, t2 where t1.Id = t2.Id