Take the 2-minute tour ×  Dealing with SQL shows us some
limitations and gives us an opportunity to imagine what could
be.  Which improvements to SQL are you waiting for? Which would
you put on top of the wish list?  I think it can be nice if you
post in your answer the database your feature request lacks.
share|improve this question Mainly what I would like to see is
some attempt to remove much of the cruft that has crept into
various dialects of SQL (many anti-relational), making them more
incompatible and complex. –  dkretz Jul 16 '09 at 20:55  46
Answers 46  T-SQL Specific: A decent way to select from a result
set returned by a stored procedure that doesn't involve putting
it into a temporary table or using some obscure function.
SELECT * FROM EXEC [master].[dbo].[xp_readerrorlog]
share|improve this answer  I know it's wildly unrealistic, but I
wish they'd make the syntax of INSERT and UPDATE consistent.
Talk about gratuitous non-orthogonality.  share|improve this
answer  Operator to manage range of dat