Viewing 15 posts - 76 through 90 (of 557 total)
---- Quote :-------------------------------------------------------------------------------------------------------------------------
I completely agree that the implementation of the OUTPUT clause for INSERT is... shall we say, disappointing.
And you're correct that there may be obstacles to modifying prod...
April 3, 2019 at 9:26 am
'Activity' of 'Activities' is probably the correct word.
But not sure.
Ben
April 2, 2019 at 7:08 pm
Thank you schleep,
One workaround is to add the OldId column to the new table, and include it in your INSERT statement. It’ll then be available to the OUTPUT..INTO.
In general you...
April 2, 2019 at 1:36 pm
Hello Scott, David, Thom and other readers.
Optimistic as I was I 'thought' that the OUTPUT clause in the INSERT (and UPDATE) statement was the solution to get the OLD identity...
April 2, 2019 at 1:24 pm
The thread
using-the-output-clause-in-a-insert-statement
Partially describes the given problem. How to resolve the identities when data gets transported from one (SQL-server) system to another SQL-server system. And There is an identity involved, which...
April 2, 2019 at 7:31 am
-- Found the formatting smily smily smily.
-- Example
-- Ben
-- 20190401
--
--
drop table A;
drop table #tempA ;
drop table resolveA
----------------–
-- Set up a table A
----------------–
Create table A...
April 1, 2019 at 2:52 pm
Hello Tom,
In the temp version of the table, you see an id, this does not get inserted into the new table.
In the example if you run : SELECT * FROM...
April 1, 2019 at 2:42 pm
deleted.IDColumn AS OldID
Oh, then you want:
<span class="pln">OUTPUT inserted</span><span class="pun">.</span><span class="pln">IDColumn </span><span class="kwd">AS</span><span class="pln"> NewID</span><span class="pun">,</span><span class="pln">
deleted</span><span class="pun">.</span><span class="pln">IDColumn...
April 1, 2019 at 1:02 pm
/*
Thanks for your anwser.
What I want is the 'OLD' and the NEW identity.
The OLD identity is the identity in a #tempA file.
Because a new Identity is inserted,...
April 1, 2019 at 12:03 pm
The one thing that's still missing is the...
March 20, 2019 at 8:30 am
March 20, 2019 at 8:20 am
Not a complete anwser/solution yet, but for readers of this thread and me this might help :
The OUTPUT Clause:
The OUTPUT Clause for UPDATE Statements
March 18, 2019 at 4:14 am
March 4, 2019 at 5:55 am
SELECT * FROM A_Table
JOIN B_table
ON A.something= B.something
All columns of A_table and of B_table are used. If there are...
March 4, 2019 at 5:50 am
Viewing 15 posts - 76 through 90 (of 557 total)