DRAG DROP
You administer a Microsoft SQL Server database that contains a table named Customer defined by the following Transact-SQL statement:
The SalesRep column contains the SQL Login name of the user designated as the customer’s sales rep.
You need to create at trigger that meets the following requirements:
– A customer’s CreditLimit can only be changed by the customer’s SalesRep.
– CreditLimit cannot be increased by more than 50 percent in any single update.
If an UPDATE statement causes either of these business rules to be violated, the entire UPDATE statement should be rolled back.
In addition, the trigger must handle single-row and multi-row update statements and should execute in the most efficient manner possible.
How should you complete the trigger? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Answer: 
Leave a Reply