Insert Statement

• Shahzadi

  Default port

  Points: 1479

  More actions

  March 12, 2008 at 3:07 am

  #788426

  Thanks all of you guys. helping me..

  this conversation really helpfull for me

  Thanks........

• Grant Fritchey

  SSC Guru

  Points: 398886

  More actions

  March 12, 2008 at 5:27 am

  #788470

  Darn it. Late to the game.

  Everything Matt said.

  😀

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 12, 2008 at 8:40 am

  #788600

  Another consideration on using Output clauses is that they work on update and delete as well.

  With delete, you can't scan the table for the rows you just deleted, for relatively obvious reasons.

  With update, if you scan the table for columns you just updated, you can also end up with rows you didn't update, if they happen to match the scanning criteria. Output only gets the ones actually affected by the current update command.

  So, if you end up using Output for those actions, it would be a point of standards and consistency to also use it for insert.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon