SQL SERVER create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table.

SQL SERVER

create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column

of the Products table. This trigger should raise an appropriate error if the discount percent

is greater than 100 or less than 0.

If the new discount percent is between 0 and 1, this trigger should modify the new discount percent

by multiplying it by 100. That way, a discount percent of .2 becomes 20.

Test this trigger with an appropriate UPDATE statement.

SQL SERVER

EX3. Using the AP database, develop your own question that could be answered by developing a stored procedure or a function.

  Code the proc or function and then test it with some queries.

SQL SERVER

Can you help me code this for Microsoft SQL Server

Write a Scalar UDF, called fnYearMonth that will take any date as an input parameter and return

that same date in the following format: YYYY-MMM example: 2018-Nov

(4 digits for the year, a hyphen, and 3 characters for the Month)

Note: the Return will be in varchar format, NOT date format

Include at least 3 statements to test this new UDF with different dates