SQL Server Performance

trigger a table

Discussion in 'Getting Started' started by comiccrazy, Jun 22, 2007.

  1. comiccrazy New Member

    hi guys,
    I am think how to implement this table.
    I need load staging table to data warehous.
    I want a table called status, and before loading, I want to insert current time and date to this table, after loading is complete, I want to insert another column to store finish time.
    can you use trigger to do it.
    how to fire trigger before and after loading.
  2. satya Moderator

Share This Page