Find modified fields in Update Trigger, Sql Server

Find modified fields in Update Trigger

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 5, rows affected: 10, absolute service time: 0,23 sec, absolute service time: 0,26 sec

fork mode | history

  
Inserted_Col
Deleted_Col
IsUpdated
NULLIF(I.Col, D.Col)
NULLIF(D.Col, I.Col)
COALESCE(NULLIF(I.Col, D.Col), NULLIF(D.Col, I.Col))

1
1
NULL
1
1
NULL
1

2
NULL
1
1
NULL
1
1

3
2
2
0
NULL
NULL
NULL

4
NULL
NULL
0
NULL
NULL
NULL

5
3
4
1
3
4
3

λ

                                      .NET NoSQL database for rapid development