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 = ...
With CU5, Microsoft has focused on key capabilities to the SQL Server, along with Big Data Clusters. One of the main improvements is deployment for BDC on the Red Hat OpenShift Kubernetes platform.