Inserting data into two tables simultanously

• Himabindu Vejella

  SSC Veteran

  Points: 221

  More actions

  March 20, 2006 at 2:32 am

  #89663

  I would like to know that is there any possible way to insert data in two tables using one insert statement in SQL server

  Not using  triggers or complex views!

  ---

  Kindest Regards,

  Himabindu Vejella
  spaces.msn.com

• Ghislain LECOMTE

  Newbie

  Points: 1

  More actions

  March 21, 2006 at 2:29 am

  #627811

  No you can't.

  However, you can wrap both insert into the same transaction to achieve similar results.