SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, OR Rss

   Items 1 to 2 of 2   

Where conditions

By Evgeny Garaev 2018/04/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,189 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 | 6,263 reads
   Items 1 to 2 of 2   
and (1)    
union (1)    
where (1)