|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, May 17, 2013 1:36 AM
Points: 99,
Visits: 28
|
|
got it right and learn a behaviour great love it
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, February 14, 2013 2:45 AM
Points: 285,
Visits: 62
|
|
Answer of the question is wrong !!
select @@VERSION create table #t1 (col int not null) create table #t2 (col int not null) create table #t3 (col int not null)
insert #t1 values (1), (1) insert #t2 values (2) insert #t3 values (3)
select COL from #t1 UNION select COL from #t2 union all select COL from #t3
select COL from #t1 UNION ALL select COL from #t2 union all select COL from #t3
Result:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Data Center Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
COL 1 2 3
COL 1 1 2 3
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 8,620,
Visits: 8,261
|
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046,
Visits: 573
|
|
not confused @ all
What you don't know won't hurt you but what you know will make you plan to know better
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074,
Visits: 1,076
|
|
great question, although I got it right, but I am glad i read the posts .Otherwise , I may have ended with wrong idea.
~ demonfox ___________________________________________________________________ Wondering what I would do next , when I am done with this one
|
|
|
|
|
SSChasing Mays
      
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 1:45 AM
Points: 616,
Visits: 97
|
|
| oops...got it wrong..simple ques yet
|
|
|
|