Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    124

    Unanswered: @@ identity insert

    Is it possible to create a trigger that inserts the @@identity (primary key) from Table1 into a field in Table2?

    If so, how? Thank you.
    -D-

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    yes it's possible. Create a trigger on Table1 for insert and execute an insert-statement using @@identity. Are you stuck?

Posting Permissions

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