Tagged Questions
8
votes
2answers
168 views
Where can I find the SQL standard document?
Where can I find a legal copy of the ISO SQL 2008 standard?
2
votes
1answer
81 views
SQL ISO Standard for group concatenation
Is there an operator in the latest standard SQL:2011 (or earlier) that will handle group concatenation the likes of which we currently have to resort to these tricks for?
GROUP_CONCAT in MySQL
FOR ...
2
votes
4answers
438 views
Should I use a Column naming convention or rely on column descriptions?
Frankly I am stunned that after some basic (very basic) internet searches I have not been able to find a comprehensive naming convention or guideline or SQL object and column naming.
The parallel ...
3
votes
4answers
166 views
Which SQL standard is most broadly and completely supported?
I want to concentrate on one of the SQL language specs for learning and reference purposes. Which version of the SQL standard is most broadly supported across DBMS'es so that I can focus my time and ...
18
votes
5answers
5k views
SQL: SELECT All columns except some
Is there a way to SELECT all columns in a table, except specific ones? IT would be very convenient for selecting all the non-blob or non-geometric columns from a table.
Something like:
SELECT * ...
3
votes
4answers
960 views
How different are the top DB vendor's SQL (DML-) dialects from each other?
Does someone who has worked extensibly SQL-wise with at least two top DB products (such as Oracle, SQL Server, Informix, Sybase, DB2, Teradata) know how different the DB vendor's SQL dialects are from ...
