triggers

• isa-369599

  SSCommitted

  Points: 1602

  More actions

  October 16, 2006 at 1:49 am

  #367652

  Hello everyone, i have 2 tables table1: "Transactions" and table2: "TransactionLog",

  In table1 i have the following fields::::::::::::::::

           

   TransactionID ,

   BuyerID,

   TransactionTypeID,

   TransactionStatusCode,

   PaymentModeID,

   SubAccountNumber,

   IsDebit,

   TransactionDate,

   DispatchDate,

   ExpireDate,

   LastStatusUpdate,

   TotalAmount,

   Discount,

   Tax,

   PaymentServiceFees,

   InstrumentNumber,

   Comments

  In table2 i have following fields::::::::::::::::::

  TransactionID,

  TransactionStatusCode,

  LogDate,

  ErrorCode,

  Comments.

  ......................................................................

   Now i want to write a trigger for Insert and Update on table1. As if any insertion is made in the table1 or update anything in tha table1 , for this a new entry is always added in table2. ( for making log activity)

  i never used triggers so plz give me solution with code

  its very urgent

  plz  plz plz reply me asap

• Lowell

  SSC Guru

  Points: 323518

  More actions

  October 18, 2006 at 9:23 am

  #666541

  something like:

  CREATE TRIGGER tr1 ON Transactions

  AFTER INSERT,UPDATE AS

  INSERT INTO TransactionLog(TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments )

  --the table [INSERTED] is  the data being affected by insert/update:

  SELECT TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments FROM [INSERTED]

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Eugene Bereznuk

  SSC Veteran

  Points: 270

  More actions

  October 20, 2006 at 6:37 am

  #667034

  Only I would use GetDate() for LogDate. So, it would seems like the following:

  CREATE TRIGGER tr1 ON Transactions

  AFTER INSERT,UPDATE AS

  INSERT INTO TransactionLog(TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments )

  SELECT TransactionID, TransactionStatusCode, GetDate(), ErrorCode, Comments FROM [INSERTED]

  Matter of taste, really.