Monday, 22 July 2024

seqnce update after delete

 UPDATE tbl_WorkFlowMembers

SET Approver_Sequence = Approver_Sequence - 1

WHERE WorkFlow_ID='RAILMY00009' AND Approver_Sequence > 1;


i have sequence like this  to make proper imporved using above like this
Approver_Sequence 1 3 4 5 6 7 8

No comments:

Post a Comment

EFcore best practice

  🌉 What is a Navigation Property? Think of navigation properties as shortcuts or links between two related tables in Entity Framework....