Understanding UNION and UNION ALL in SQL Server
A short look at the differences in UNION and UNION ALL in a SELECT query.
2025-04-07
3,829 reads
A short look at the differences in UNION and UNION ALL in a SELECT query.
2025-04-07
3,829 reads
Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?
2019-12-05
2018-06-12
1,056 reads
2016-11-15
1,307 reads
2016-05-31
1,590 reads
The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.
2013-05-14 (first published: 2013-04-30)
920 reads
2012-03-08
2,805 reads
As AI continues to evolve, many of us are looking for ways to leverage...
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Yeah, yeah, second AI post in a row. I promise not to make a...
Hi everyone I am looking at the size of my db on disk (ie...
Comments posted to this topic are about the item Getting the TEXTSIZE
Comments posted to this topic are about the item The Return to the Office...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers