Loading

how to identify record is not updated in Sql server

prasanna p

5y987

hi Friends,

I am inserting records into a datatable after insertion , max(sno) lessathan rows I am deleting.

No When record is not inserting means SNO is not changing I need to delete that record immediatly.I have row created time field in the table.

how to delete record when the SNO is not changed?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Basem Alshabani5y ago
- You can use trigger that fire after insert and execute a select statement from the inserted table
- You can put the insert statement inside a try catch block
+1