Replace old database record with new one?

Member111y ago

Accepted answer

You can do this by (Update if exists else insert) refer below link.

http://stackoverflow.com/questions/21208719/update-if-exists-else-insert-in-sql-server-2008

+1

shosho shosho11y ago

How do i write this in code?

0

Khargesh Rajput11y ago

delete particular record and insert new record

0

Manoj Bhoir11y ago

Hi,

You said StudentId and DateOfJoining these are the two Primary Key columns. So I will suggest you while inserting record into your database first check that record for same StudentId and DateOfJoining is present in your database or not. If it is already present then delete the existing record and then you can insert new record in your database.

0