Viewing 5 posts - 1 through 5 (of 5 total)
No, the exec plan definitely survived - there was still the same, weeks old creation_time.
Moreover, should there be a reset of all columns/values, I would have no issue with that....
October 20, 2021 at 1:33 pm
g.britton (6/17/2016)
Also, to be clear, there are highly useful features in many SQL versions that are not supported by others. We use them nonetheless
We use them too - but...
June 17, 2016 at 5:07 am
g.britton (6/16/2016)
obouda (6/13/2016)
I vote for the CTE/subquery approach.The day you're porting your SQL to another database engine, e.g. ORACLE, you'll damn all of the MSSQL-specific code 🙂
I have a feeling...
June 16, 2016 at 11:52 pm
If the tables have the same columns, comparison is easy:
select * from A
except
select * from B
--
union all
--
select * from B
except
select * from A
;
Moreover, this approach works also on tables without...
June 14, 2016 at 9:10 am
I vote for the CTE/subquery approach.
The day you're porting your SQL to another database engine, e.g. ORACLE, you'll damn all of the MSSQL-specific code 🙂
June 13, 2016 at 9:25 am
Viewing 5 posts - 1 through 5 (of 5 total)