here’s a wake up call for devs who use SQL Unions infrequently. at work we recently tripped up on a bug with a stored proc… well it was actually just that we had forgotten that with UNION, only distinct values are selected! oops.
so remember: The UNION ALL command is equal to the UNION command, except [...]
-
-
Categories
-
My RSS Feeds
-
Meta
-
-
Bookmarks
- Aaron Bulkley
- Austin Events
- Austin Graphic Designer
- Benny Cornett
- Computer Dictionary
- Dallas Cowboys Tickets
- Double Danger
- Eric Gehrman
- Fantasy Football Blog
- FTP Commands
- iPhone Hacks
- Law Dictionary
- Legal Abbreviations
- Legal Dictionary
- Medical Conditions
- Medical Dictionary
- Ravens at Cowboys
- Shaun Collings
- Ticket Broker Blog
- Ticket Brokers
- Tim Tipton
- Website Colors
-
Archives
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005