<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
UNION
Items 1 to 10 of 10
Union Forcing Distinct
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.
Read more...
By
Clyde Merrell
2013/05/14
|
Source:
SQLServerCentral.com
|
Category:
union
Rating:
|
Discuss
|
Briefcase
|
553 reads
Combining union and union all
Read more...
By
Richard Rozema
2012/03/08
|
Category:
union
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,575 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Read more...
By
David Poole
2011/12/23 (first published: 2009/07/20)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
39,452 reads
exceptional logic
Read more...
By
BenWard
2011/10/11
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,435 reads
Union results
Read more...
By
Jason Whisman
2011/09/22
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,552 reads
Whether to use UNION or OR in SQL Server Queries
Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database
Read more...
By
Additional Articles
2011/07/06
|
Source:
SQL Server Performance
|
Category:
t-sql
Rating:
Rate this
|
Briefcase
|
5,851 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Read more...
By
David Poole
2011/12/23 (first published: 2009/07/20)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
39,452 reads
Converting Access Queries with iff() and DLookup() to SQL Server
This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.
Read more...
By
Fred Simmons
2010/03/08
|
Source:
SQLServerCentral.com
|
Category:
access
Rating:
|
Discuss
|
Briefcase
|
7,596 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Read more...
By
David Poole
2011/12/23 (first published: 2009/07/20)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
39,452 reads
Using the Union Statement - SQL School Video
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
Read more...
By
Andy Warren
2009/03/24
|
Source:
SQLServerCentral.com
|
Category:
video
Rating:
|
Discuss
|
Briefcase
|
6,371 reads
Items 1 to 10 of 10
Tags
t-sql
(6)
except
(2)
union all
(2)
access
(1)
distinct
(1)
dlookup
(1)
iif
(1)
intersect
(1)
or
(1)
video
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
