Results 1 to 2 of 2

Thread: hello

  1. #1
    Join Date
    Jul 2011
    Posts
    4

    Unanswered: hello

    can any one suggest me how to insert data into two tables at a time haveing pk and fk relation means..
    i have 2 tables, emplyeeinformation table with emp_id as PK and another table empsalary
    haveing emp_id as FK of employeeinformation table emp_id
    so if i insert data into first table should also insert same data into another table emp_id..
    plz suggest how to solve this...

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The simplest answer is to use a stored procedure to handle the insert operations.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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