help for n00b

• Ehsan Ashouri

  SSC Veteran

  Points: 241

  More actions

  October 6, 2005 at 5:24 am

  #169271

  Hi couple of questions....

  1)  What kind of database object is 'inserted'?

  2)  After an SQL 'update' command, will the number of rows 'inserted'

  necessarily  be the same as 'deleted'

    any help greatly appreciated!  Cheers

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  October 6, 2005 at 5:41 am

  #595407

  1.  Data is inserted into Tables ??

  2.  AFAIK they should be equal.  If they aren't there would be a problem because you would have deleted more rows than inserted...

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  October 6, 2005 at 7:44 am

  #595464

  Are you talking about the 'inserted' and 'deleted' tables in a trigger? or did AJ's response answer your question for you?

   

• Ehsan Ashouri

  SSC Veteran

  Points: 241

  More actions

  October 6, 2005 at 9:43 am

  #595534

  hey yes, I think what are inserted are the transition values e.g. inserted deleted old_update, new_update but i am unsure....

    Cheers!