Hi. Can anybody tell me how can I update a column of a record when it is inserted to the database. Here's the pseudocode that I want.
if( mytable.OriginalId == null )
mytable.OriginalId = Scope_Identity();
views:
26answers:
1
+1
A:
This would be contradictory I think. Either OriginalId is set or it isn't on insert.
If it isn't where does Scope_Identity() get it's value from? If it's from another column then would it not be better to use a computed column?
Sorry, it's not clear what the overall objective is... you would not normally use a trigger especially if OriginalId is part of the PK
gbn
2010-10-03 10:11:43
Sorry, I should have mentioned. The PK is another column called "Id".
Mohammadreza
2010-10-03 10:23:11
Thanks. And should OriginalId always be the same as ID? or different?
gbn
2010-10-03 10:47:56
If the user sets it to null it should be the same as ID otherwise it should be whatever user wants.
Mohammadreza
2010-10-03 11:43:06