Results 1 to 2 of 2

Thread: Help With SQL Triggers!!

  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Help With SQL Triggers!!

    This is what I had to do for my assigment!! I am just checking if this is correct!! Any help would be nice!! Thank You in Advance!

    Create and test the following triggers for the database created in Programming Assignment 6.

    1. A trigger that prevents the number of miles on a truck from being decreased.

    This what I did for this one!

    CREATE TRIGGER TURCK_MILES ON TRUCK
    FOR INSERT,UPDATE
    AS
    declare @v1 decimal(8,2)
    declare @v2 decimal(8,2)
    select @v1 = TRUCK_MILES FROM TURCK
    BEGIN
    ROLLBACK
    END


    2. A trigger that prevents the Buy Date for truck from being after the current date.

    This is what I put!

    CREATE TRIGGER TRUCK_BUY_DATE ON TRUCK
    FOR INSERT,UPDATE
    AS
    declare @date DATETIME
    select @date=inserted.TRUCK_BUY_DATE FROM INSERTED
    IF @date>GETDATE()
    BEGIN
    ROLLBACK TRANSACTION
    END


    3. A trigger that ensures that the Base Code in the Truck table is always in the Base table

    My Answer!

    CREATE TRIGGER BASE_CODE ON TRUCK
    FOR INSERT,UPDATE
    AS
    declare @1_base_code int
    declare @2_base_code int
    select @1_base_code=inserted.BASE_CODE
    FROM INSERTED,BASE,TRUCK
    IF @1_base_code<>@2_base_code
    BEGIN
    ROLLBACK TRANSACTION
    END

  2. #2
    Join Date
    Apr 2011
    Posts
    2
    You do not need a trigger for that.
    All you need is a Check Constraint that forces the dates to be older than Right Now

    ALTER TABLE TRUCK
    ADD CONSTRAINT CheckValidDate CHECK (TRUCK_BUY_DATE >= GETDATE() );
    DbDefence - transparent database encryption and SQL protection

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •