inserting data into multiple tables

• puresmile

  Old Hand

  Points: 387

  More actions

  June 22, 2006 at 9:31 pm

  #112681

  i'm trying to create new user in my application. Data would be enter in sql server 2000.

  personal info of that user would be in one table while login info would be in separate table.these are present on a single web form. Also in both tables; userId is present and these are related with each other through it, if one is entered other should be automatically inserted. now i'm confused how to insert this data?

• Prakash Sawant

  SSCrazy

  Points: 2173

  More actions

  June 23, 2006 at 1:57 am

  #645469

  You can use "INSTEAD OF TRIGGER" on the main table & insert the data in both the tables.

   

   

  ------------
  Prakash Sawant

  http://psawant.blogspot.com