Results 1 to 3 of 3

Thread: [RESOLVED] create trigger

Threaded View

  1. Oct 18th, 2011, 01:33 AM #1
    deshpandesn
    deshpandesn is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2006
    Location
    Aurangabad
    Posts
    25

    Resolved [RESOLVED] create trigger

    Hi Everybody i want to create trigger in sql server 2008 database
    i want to insert data into another table in same database after parent database inserted record

    i am trying something like this

    CREATE TRIGGER INS_LOGDATA
    ON NGAC_AUTHLOG
    AFTER
    INSERT
    (select Userid,Transactiontime from NGAC_AUTHLOG )
    AS Insert into LOGDATA values (Userid,ActDate,ActTime) values (Userid,ActDate,ActTime)
    Last edited by deshpandesn; Oct 18th, 2011 at 01:40 AM. Reason: additional information
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width