Message
From
28/08/2016 20:24:28
To
28/08/2016 20:09:56
Miscellaneous
Thread ID:
01640098
Message ID:
01640109
Views:
37
>>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.
Of course the table has a primary key; all tables of my SQL server database have primary keys. Thank you for clarifying your point.
>
>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.
Of course the table has a primary key; all tables of my SQL server database have primary keys. Thank you for clarifying your point.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham