First: CREATE TRIGGER [Update Data] ON [dbo] [TABLE1] FOR updateASif @@ datefirst = 5 returnSET DATEFIRST 5update table1set table1 order = table1 order 1 from table1, inserted, deletedwhere table1 order> = inserted.... Sequential and deleted. Sequence <> inserted. Order Set DateFirst 7
Second: CREATE TRIGGER [Delete Data] ON [DBO]. [Table1] for deleteasset DateFirst 5
Update Table1Set Table1. Order = Table1. Order - 1 from Table1, DeletedWhere Table1. Order> DELETED. Order
Set DateFirst 7
Third: Create Trigger [Add Data] ON [DBO]. [Table1] for Insertasset DateFirst 5Update Table1Set Table1. Order = Table1. Order 1 from Table1, Insertedwhere Table1. Order> = INSERTED. Order and Table1. Number <> INSERTED. Number Set DateFirst 7
