I have used both formats; I usually don't notice on the servers. But most of my servers are pretty powerful; but I have shown both those syntax to developers.
And most of my developer buddies hate UNION ALL because they find it it makes it hard to read. I liked Union all because I don't have to do INSERT INTO .blah blah again...
Me ((0.02/10)/10) cents o.O there is such thing right :doze:
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]