Message
From
28/08/2016 20:09:56
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01640098
Message ID:
01640108
Views:
42
>What does PK definition have to do with my question? (btw, I am too young to remember 1970 commercials)

It's an add-on comment for the solution.

For Naomi's solution to work (and her trigger code solution is a good solution), you need a primary key definition. Otherwise, you can't tie the rows in the inserted table (in the trigger) back to the original rows.
Previous
Next
Reply
Map
View