p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   UNION in SQL (http://p2p.wrox.com/showthread.php?t=80281)

anwarraja July 27th, 2010 07:36 AM

UNION in SQL
 
Why Union is not accept image?
where as union all accept that.[:p][:p]

joefawcett July 27th, 2010 07:43 AM

Because UNION (without ALL) deduplicates and to do this it has to compare data which it can't do for IMAGE type fields. Just as you can't sort on such types.

Imar July 27th, 2010 07:43 AM

I think because a UNION uses DISTINCT to filter out duplicate rows. DISTINCT is not supported for types such as Image.

Hope this helps,

Imar

Old Pedant July 27th, 2010 02:16 PM

LOL!!! Man, do you guys run a race to see who posts the fastest?? Too bad the post times don't show down to the millisecond. <grin/>


All times are GMT -4. The time now is 07:27 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.