You need to automate the process of updating the primary key tools. You also want to minimize records locks and administration within the database during the update process.
What should you do?
A.Add an ON UPDATE CASCADE constraint to the CustomerID field in the Customers table. Modify the values in the CustomerID field in the Customers table.
B.Create a duplicate record that has a new CustomerID value. Update the foreign key fields in the invoices, contacts, and quotes tables with the new value.
C.Disable the FOREIGN KEY constraints. Within a transaction, modify the values in the CustomerID field in the Customers table and all related foreign key values in the invoices, contacts, and quotes tables. Re-enable the FOREIGN KEY constraints after the keys are changed.
D.Create a Data Transformation Services package. Use the package to transform. the CustomerID value and the values of the related foreign keys in the invoices, contacts, and quotes tables.
第2题
阀门代号J41T-16中,16表示()。
A.耐压1.6Mpa;
B.耐压16Mpa;
C.耐压1.6kg
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!