GenesisTech
asked on
SQL Server "linked" table
I have something going on that I have never seen before.
I created a table by using the following code:
SELECT * INTO NEWTable FROM OLDTable
Now, whenever I update a row in either table, it automatically gets updated in the other. Or, if I insert a new row, it gets inserted into the other.
What is happening?
I created a table by using the following code:
SELECT * INTO NEWTable FROM OLDTable
Now, whenever I update a row in either table, it automatically gets updated in the other. Or, if I insert a new row, it gets inserted into the other.
What is happening?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As happens many times it technology, I discovered that I had made a typo leading to the issue.
Thanks again for your time and answer!