Posted by: U?Me June 9, 2008
Login in to Rate this Post:
0 
? 
?
Hi,
Now, There is a column in both Table A and Table B. Insertion in Table A works, but how do I update that value in Table B.?
Thanks in Advance!
Yes, AccountCode is a unique
non-clustered index:
When I insert the data into Live Table A, all other fields but this(Represented by Account) will be displayed o because it is
derived from this unique non-clustered index.
I tried to do an insertion on Table B (where the Account # is), but I got this error:
Msg 2601, Level
14, State 3, Line 1
Cannot insert
duplicate key row in object ''B'with unique index
'AccountCode'.
The statement has
been terminated.
(0 row(s)
affected)
Now, There is a column in both Table A and Table B. Insertion in Table A works, but how do I update that value in Table B.?
Thanks in Advance!