How to get the PK value within an update trigger
-
Hi Within an update trigger I am trying to get the value of the primary key of the row that fired the trigger. I can't select the primary key using any of the other columns either since the other columns may be duplicated in rows other than the one that fired the trigger. Thanks
There are 10 types of people in the world, those who understand binary and those who dont.
-
Hi Within an update trigger I am trying to get the value of the primary key of the row that fired the trigger. I can't select the primary key using any of the other columns either since the other columns may be duplicated in rows other than the one that fired the trigger. Thanks
There are 10 types of people in the world, those who understand binary and those who dont.
If you are using Sql Server, you can select the value from the deleted table in your trigger. Trust me - it sounds strange, but it does work.
Deja View - the feeling that you've seen this post before.
-
If you are using Sql Server, you can select the value from the deleted table in your trigger. Trust me - it sounds strange, but it does work.
Deja View - the feeling that you've seen this post before.