| http://www.w3.org/ns/prov#value | - Hi,what is the best way, so locks can be avoided and other problems, a table with joins to other ones?I read that using alias on the table being updated can cause locks and I see o lot of those...UPDATE t SET t.c0 = j.c0, t.c1 = j.c1 FROM tableToUpdate t INNER JOIN joinTable j ON t.Id = p.IdFromT-- vs --UPDATE tableToUpdate SET tableToUpdate.c0 = j.c0, tableToUpdate.c1 = j.c1 FROM joinTable j WHERE
|
