12. Triggers and Audit Trail - Designing Database Solutions with Microsoft SQL Server 2022

[@radoslavdimitrov7505]

when I do select * from inserted or select * from deleted outside of a trigger it doesn't work, says there is no such object. I am using SQL Server Developer Edition 2022. Could you explain why?

[@santhiPatnana]

How to display which column name delete or update.... its possible or not

[@nishagupta9520]

you have not inserted anything for id in products , nor in product in productsaudit , if i m trying to do the same , i m getting columns do not match .. you have not do any type of autoincrement . can u reply

[@joedgoh]

Yes, please add autoincrement attributes to the IDs of your tables. Thanks.

[@shaliniasadi6757]

tq