CREATE PROCEDURE Tools
(
    @Mode nvarchar(100), 
    @CategoryID int,
    @CategoryName nvarchar(100),
    @Description ntext
)

AS 
BEGIN 
    IF @Mode = 'INSERT'
    BEGIN
        INSERT INTO Categories (CategoryID, CategoryName, Description) 
        VALUES (@CategoryID, @CategoryName, @Description)

CREATE PROCEDURE Tools
(@CategoryID_1 int,
 @CategoryName_2 nvarchar(100),
 @Description_3 ntext)

AS INSERT INTO Categories 
 (CategoryID,
 CategoryName,
 Description) 

VALUES 
(@CategoryID_1,

CREATE TRIGGER Super1

    ON Products

    AFTER Update

    AS

    BEGIN

    DECLARE @ProductID int,
     	    @ProductName nvarchar,
    	    @SupplierID varchar,
    	    @CategoryID int,
    	    @QuantityPerUnit int,
    	    @UnitPrice money,
    	    @UnitsInStock smallint,
    	    @UnitsOnOrder

CREATE TRIGGER Super1 ON  Products
   AFTER UPDATE, INSERT
AS

CREATE TRIGGER Super 

ON Products 

AFTER INSERT, UPDATE

AS

UPDATE Product_audit (Column1,Column2, Column3, ... )

SELECT (Column1,Column2,Column3,...)

FROM Products

DECLARE @Average_cost money

SELECT @Average_cost = AVG(UnitPrice)  FROM Products  
UPDATE Products
SET UnitPrice = (CASE WHEN UnitPrice > @Average_cost 
                      THEN UnitPrice - (UnitPrice * .1)
                      WHEN UnitPrice < @Average_cost 
                      THEN UnitPrice + (UnitPrice * .2)  
                      ELSE @Average_cost

DECLARE @Average_cost money(8)

SELECT @Average_cost = AVG(UnitPrice)  FROM Products 

UPDATE Products
SET UnitPrice = (CASE WHEN UnitPrice > @Average_cost 
                      THEN UnitPrice - UnitPrice/10 
                      ELSE UnitPrice < @Average_cost 
                      THEN UnitPrice - UnitPrice/20                      
                END)

UPDATE Products
SET UnitPrice = CASE WHEN UnitPrice > @Average_cost THEN -10% ELSE UnitPrice < @Average_cost THEN + 20%

DECLARE @Average cost

SELECT @Average cost = AVG(UnitPrice)  FROM Products  


Update Products

Set UnitPrice = @Average cost

DECLARE @Computing

IF UnitPrice > @Average cost SET@Computing= -10%

ELSE SET IF UnitPrice < @Averaeg cost SET@Computing = +20%

DECLARE @Average cost

SELECT @Average cost = AVG(UnitPrice)  FROM Products  


Update Products

Set UnitPrice = @Average cost

DECLARE @Computing

IF