Valid 70-762 Dumps shared by ExamDiscuss.com for Helping Passing 70-762 Exam! ExamDiscuss.com now offer the newest 70-762 exam dumps, the ExamDiscuss.com 70-762 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-762 dumps with Test Engine here:
Note: this question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in the series. Information and details provided in a question apply only to that question. You are developing an application to track customer sales. You need to create a database object that meets the following requirements: - Return a value of 0 if data inserted successfully into the Customers table. - Return a value of 1 if data is not inserted successfully into the Customers table. - Support TRY...CATCH error handling - Be written by using Transact-SQL statements. What should you create?
Correct Answer: D
Explanation/Reference: Explanation: DML triggers is a special type of stored procedure that automatically takes effect when a data manipulation language (DML) event takes place that affects the table or view defined in the trigger. DML events include INSERT, UPDATE, or DELETE statements. DML triggers can be usedto enforce business rules and data integrity, query other tables, and include complex Transact-SQL statements. References:https://msdn.microsoft.com/en-us/library/ms178110.aspx