/*set identity_insert Modality ON

insert into Modality (ModalityKey, ModalityName, ModalityTypeCd) Values (1, 'ZZ', 'ZZ')

set identity_insert Modality OFF*/

set identity_insert Patient ON

insert into Patient (PatientKey, Gender, MaritalStatus) Values (1, 'U', 'U')

set identity_insert Patient OFF