DELETE

• heero

  Mr or Mrs. 500

  Points: 521

  More actions

  September 17, 2002 at 8:56 pm

  #101253

  hi

  i would like to find out if the delete statement can delete from 2 tables once and for all....

  pls giv me some advice.. thank alot.. =)

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 18, 2002 at 4:48 am

  #436749

  No.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Clive Strong

  SSChampion

  Points: 11222

  More actions

  September 18, 2002 at 4:52 am

  #436750

  Staightest answer you'll ever get!! hehe

  I'd go for two statements within a transaction. That way either they both complete or none complete.

  Clive Strong

  clivestrong@btinternet.com