Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Union Vs Union All

Apr 3 2008 2:25PM by Madhivanan   

Well. Most of you know the diffrence between the two.

http://blog.sqlauthority.com/2007/03/10/sql-server-union-vs-union-all-which-is-better-for-performance/

http://www.codethinked.com/post/2007/11/UNION-versus-UNION-ALL2c-lessons-in-minutiae.aspx

Here is one of the differences that is not known by newbies When you use UNION, you cant include any column of type TEXT and NTEXT. But it is possible if you use UNION ALL

 

Declare @test table(i int, text_col text)
insert into @test 
select 1,'some test string'union all
select 2,'some other test string' 

--Error For UNION
select i,text_col from @test where i=1
union 
select i,text_col from @test where i=1

--No Error for UNION ALL

select i,text_col from @test where i=1
union all
select i,text_col from @test where i=1

Tags: t-sql, sql_server, union all, union,


Madhivanan
3 · 40% · 12936
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • gud one

    commented on Sep 6 2011 6:33AM
    mrajesh
    660 · 0% · 51

Your Comment


Sign Up or Login to post a comment.

"Union Vs Union All" rated 5 out of 5 by 1 readers
Union Vs Union All , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]