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.
    thanks.
  2. satya Moderator

Share This Page