clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 497144 fiddles created (9372 in the last week).

declare @v1 varchar(1) = 'a'; declare @v2 varchar(max) = 'a'; set statistics profile on; select @v1 union all select @v2; select cast(@v1 as varchar(10)) union all select cast(@v2 as varchar(10));
(No column name)
a
a
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select @v1 union all select @v2 1 1 0 2 2.157E-06 SELECT False
2 1 |--Constant Scan(VALUES:((CONVERT_IMPLICIT(varchar(max),[@v1],0)),([@v2]))) 1 2 1 Constant Scan Constant Scan VALUES:((CONVERT_IMPLICIT(varchar(max),[@v1],0)),([@v2])) 2 0 2.157E-06 4035 2.157E-06 [Union1001] PLAN_ROW False 1
(No column name)
a
a
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
2 1 select cast(@v1 as varchar(10)) union all select cast(@v2 as varchar(10)) 2 1 0 2 2.157E-06 SELECT False
2 1 |--Constant Scan(VALUES:((CONVERT(varchar(10),[@v1],0)),(CONVERT(varchar(10),[@v2],0)))) 2 2 1 Constant Scan Constant Scan VALUES:((CONVERT(varchar(10),[@v1],0)),(CONVERT(varchar(10),[@v2],0))) 2 0 2.157E-06 16 2.157E-06 [Union1002] PLAN_ROW False 1
 hidden batch(es)