CREATE TRIGGER tr_person_setPersonID ON person AFTER INSERT AS DECLARE @newid int SET @newid = (select max(P.person_id) + 1 FROM person P JOIN inserted i ON i.study_id = P.study_id WHERE p.study_id = ...
I'm trying to figure out whether to kill a large series of update operations on a table after discovering that the table doesn't have any of the usual indexes on it. But I can't decide or find ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results