New answers tagged import
Your table is owned by USERGOD, but you are importing as DIGITALNOISE. Yes, you have the IMPORT FULL DATABASE, but you are not doing a full import. Using FROMUSER/TOUSER is one solution. Performing a full import by adding the FULL=Y option is another.
You can use a variant of the technique described in Using merge..output to get mapping between source.id and target.id and by Adam Machanic in Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE. You use merge and capture the generated ID with the XML fragment that belongs to that ID in a table variable and then use that table variable when ...
Top 50 recent answers are included