Insertion / Updation of rows

• Rajesh Kumar Singh

  SSC-Addicted

  Points: 454

  More actions

  October 6, 2005 at 11:58 pm

  #87967

  Hi ALL,

  I want to insert rows into a table, say table emp which has primary key empid.

  If empid is already  present it should update..otherwise insert. Something like MERGE command in Oracle.

  Which is the best way to implement the baove functionality ?

  Regards,

  Rajesh

   

• Deni Kusdeni

  Default port

  Points: 1457

  More actions

  October 7, 2005 at 12:09 am

  #595772

  You can create trigger for inserting.

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  October 7, 2005 at 5:58 am

  #595820

  I would use a stored procedure - pass the empID (& other values) as parameters...

  & then do an

  
  if exists(select * from myTable where empID = @empID)
          update.....
  else
          insert into...
  

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**