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?
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
tq
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?
How to display which column name delete or update.... its possible or not
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
Yes, please add autoincrement attributes to the IDs of your tables. Thanks.