inserting into two tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: inserting into two tables

  1. #1
    Join Date
    Apr 2001
    Posts
    60
    Hi

    Is there any way to insert the data into two tables with single insert statement?

    rammi

  2. #2
    Join Date
    Apr 2001
    Posts
    14
    No. you have to use it as two different sql insert commands. if you want to insert into two tables simultaneously then use an insert trigger on one table and within the trigger write the insert statement for the second table
    Anil
    anil_tj@yahoo.com

Posting Permissions

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



Click Here to Expand Forum to Full Width