This is using the adventureworks2019 database 5) Create an insert/update trigger on the Vendors table that uppercases

This is using the adventureworks2019 database

Transcribed Image Text:

5) Create an insert/update trigger on the Vendors table that uppercases and trims the follwing fields: (VendorName. VendorAddress 1, VendorAddress2, VendorCity. VendorState VendorContractL Name, and VendorContactFName) Create an insert and update statement with lowercase values to test your trigger. Show a select of the table afterwords to prove your trigger worked. 5) Create an insert/update trigger on the Vendors table that uppercases and trims the follwing fields: (VendorName. VendorAddress 1, VendorAddress2, VendorCity. VendorState VendorContractL Name, and VendorContactFName) Create an insert and update statement with lowercase values to test your trigger. Show a select of the table afterwords to prove your trigger worked.