SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DECLARE @T table
(
    Id integer IDENTITY NOT NULL PRIMARY KEY, 
    [Hash] binary(16) NOT NULL INDEX h
);

INSERT @T ([Hash]) VALUES (0x31F777F0804D301936411E3ECD760859);
INSERT @T ([Hash]) VALUES (0xD64A593F3E9ACC972158D522A4289EA0);

DECLARE @S table 
(
    [Hash] binary(16) NOT NULL
);

INSERT @S
    ([Hash])
VALUES
    (0x31F777F0804D301936411E3ECD760859),
    (0x31F777F0804D301936411E3ECD760859),
    (0x0C5A65264F92A543E7AAA06375349C06);

SET STATISTICS XML ON;

WITH ToDelete AS
(
    SELECT
        T.*
    FROM @T AS T
    WHERE 
        NOT EXISTS 
        (
            SELECT
                S.* 
            FROM @S AS S 
            WHERE 
                S.[Hash] = T.[Hash]
        )
)
DELETE ToDelete;

WITH ToInsert AS
(
    SELECT
        S.[Hash], 
        rn = ROW_NUMBER() OVER (
            PARTITION BY S.[Hash] 
            ORDER BY S.[Hash])
    FROM @S AS S
    EXCEPT
    SELECT
        T.[Hash], 
        rn = ROW_NUMBER() OVER (
            PARTITION BY T.[Hash] 
            ORDER BY T.[Hash], T.Id)
    FROM @T AS T
)
INSERT @T
    ([Hash])
SELECT
    ToInsert.[Hash]
FROM ToInsert;

SET STATISTICS XML OFF;

SELECT * FROM @T AS T ORDER BY T.Id

Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.3.1" Build="12.0.5589.7"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH ToDelete AS ( SELECT T.* FROM @T AS T WHERE NOT EXISTS ( SELECT S.* FROM @S AS S WHERE S.[Hash] = T.[Hash] ) ) DELETE ToDelete" StatementId="1" StatementCompId="7" StatementType="DELETE" RetrievedFromCache="true" StatementSubTreeCost="0.0265727" StatementEstRows="1" StatementOptmLevel="FULL" QueryHash="0x62C74C26A76E236F" QueryPlanHash="0x71D097A56385969D" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="328"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209662" EstimatedPagesCached="13103" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="377816"/><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"/></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Clustered Index Delete" LogicalOp="Delete" EstimateRows="1" EstimateIO="0.02" EstimateCPU="2e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0265727" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><Update DMLRequestSort="0"><Object Table="[@T]" Index="[PK__#A848884__3214EC0757AE41A1]" Alias="[T]" Storage="RowStore"/><Object Table="[@T]" Index="[h]" Alias="[T]" Storage="RowStore"/><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Left Anti Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00657068" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@T" Alias="[T]" Column="Id"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="@S.[Hash] as [S].[Hash]=@T.[Hash] as [T].[Hash]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="2" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@T" Alias="[T]" Column="Id"/><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="@T" Alias="[T]" Column="Id"/></DefinedValue><DefinedValue><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></DefinedValue></DefinedValues><Object Table="[@T]" Index="[h]" Alias="[T]" Storage="RowStore"/></IndexScan></RelOp><RelOp NodeId="3" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="2"/></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></DefinedValue></DefinedValues><Object Table="[@S]" Alias="[S]" Storage="RowStore"/></TableScan></RelOp></NestedLoops></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

Microsoft SQL Server 2005 XML Showplan

Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.3.1" Build="12.0.5589.7"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH ToInsert AS ( SELECT S.[Hash], rn = ROW_NUMBER() OVER ( PARTITION BY S.[Hash] ORDER BY S.[Hash]) FROM @S AS S EXCEPT SELECT T.[Hash], rn = ROW_NUMBER() OVER ( PARTITION BY T.[Hash] ORDER BY T.[Hash], T.Id) FROM @T AS T ) INSERT @T ([Hash]) SELECT ToInsert.[Hash] FROM ToInsert" StatementId="2" StatementCompId="8" StatementType="INSERT" RetrievedFromCache="true" StatementSubTreeCost="0.0511611" StatementEstRows="1" StatementOptmLevel="FULL" QueryHash="0x84D0BAEE160CD2F5" QueryPlanHash="0xAFD1360F00EC5740" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="32" CompileTime="15" CompileCPU="15" CompileMemory="464"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" MaxQueryMemory="291568"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209662" EstimatedPagesCached="13103" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="377816"/><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"/></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.02" EstimateCPU="2e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0511611" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList/><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><Update DMLRequestSort="0"><Object Table="[@T]" Index="[PK__#A848884__3214EC0757AE41A1]" Storage="RowStore"/><Object Table="[@T]" Index="[h]" Storage="RowStore"/><SetPredicate><ScalarOperator ScalarString="[Hash] = @S.[Hash] as [S].[Hash],[Id] = [Expr1007]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Column="Hash"/><ScalarOperator><Identifier><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></Identifier></ScalarOperator></Assign><Assign><ColumnReference Column="Id"/><ScalarOperator><Identifier><ColumnReference Column="Expr1007"/></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0311591" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/><ColumnReference Column="Expr1007"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><ComputeScalar ComputeSequence="1"><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"/><ScalarOperator ScalarString="getidentity((-1471641527),(2),N'@T')"><Intrinsic FunctionName="getidentity"><ScalarOperator><Const ConstValue="(-1471641527)"/></ScalarOperator><ScalarOperator><Const ConstValue="(2)"/></ScalarOperator><ScalarOperator><Const ConstValue="N'@T'"/></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Table Spool" LogicalOp="Eager Spool" EstimateRows="1" EstimateIO="0.013125" EstimateCPU="0.00010046" AvgRowSize="23" EstimatedTotalSubtreeCost="0.031159" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><Spool><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Anti Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0179336" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="@S.[Hash] as [S].[Hash]=@T.[Hash] as [T].[Hash] AND [Expr1004] = [Expr1006]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1006"/></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-006" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0146455" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/><ColumnReference Column="Expr1004"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><StreamAggregate><DefinedValues/><GroupBy><ColumnReference Table="@S" Alias="[S]" Column="Hash"/><ColumnReference Column="Expr1004"/></GroupBy><RelOp NodeId="5" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-008" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0146445" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/><ColumnReference Column="Expr1004"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"/><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"/></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-008" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0146444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/><ColumnReference Column="Segment1008"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><Segment><GroupBy><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></GroupBy><SegmentColumn><ColumnReference Column="Segment1008"/></SegmentColumn><RelOp NodeId="7" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="1" EstimateIO="0.0112613" EstimateCPU="0.000100023" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0146444" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></OutputList><MemoryFractions Input="1" Output="1"/><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></OrderByColumn></OrderBy><RelOp NodeId="8" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="@S" Alias="[S]" Column="Hash"/></DefinedValue></DefinedValues><Object Table="[@S]" Alias="[S]" Storage="RowStore"/></TableScan></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></StreamAggregate></RelOp><RelOp NodeId="13" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="8e-008" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0032832" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@T" Alias="[T]" Column="Hash"/><ColumnReference Column="Expr1006"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="3"/></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"/><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"/></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-008" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00328312" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@T" Alias="[T]" Column="Id"/><ColumnReference Table="@T" Alias="[T]" Column="Hash"/><ColumnReference Column="Segment1009"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="3"/></RunTimeInformation><Segment><GroupBy><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></GroupBy><SegmentColumn><ColumnReference Column="Segment1009"/></SegmentColumn><RelOp NodeId="15" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@T" Alias="[T]" Column="Id"/><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="2" ActualExecutions="3"/></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="@T" Alias="[T]" Column="Id"/></DefinedValue><DefinedValue><ColumnReference Table="@T" Alias="[T]" Column="Hash"/></DefinedValue></DefinedValues><Object Table="[@T]" Index="[h]" Alias="[T]" Storage="RowStore"/></IndexScan></RelOp></Segment></RelOp></SequenceProject></RelOp></NestedLoops></RelOp></Spool></RelOp></ComputeScalar></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

Microsoft SQL Server 2005 XML Showplan

Id	Hash
1	0x31F777F0804D301936411E3ECD760859
3	0x0C5A65264F92A543E7AAA06375349C06
4	0x31F777F0804D301936411E3ECD760859