Questions tagged [style]
The style tag has no usage guidance.
4
questions
1
vote
2
answers
46
views
Name of SQL programming style where KEYWORDS | CRITERIA are justified to centering line
Is there a name for this kind of SQL programming style?
--Courtesy of Markus Winand of modern-sql.com/
SELECT *
FROM (SELECT cities.*
, ROW_NUMBER() OVER(PARTITION BY country ORDER BY ...
- 1,447
5
votes
2
answers
250
views
Are there other sites forbidding SQL developer to use c style comments?
My personal opinion is that C style comments should not be used by sql developers.
The problem with C Style comments is, that they do not nest.
C Style comments are one of the lifesavers for the ...
- 12.2k
8
votes
2
answers
1k
views
Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?
Years ago, it was common to write
where exists (Select * from some_table where some_condition)
Last year I noticed that many t-sql scripts switched to using the number 1 instead of the star
where ...
- 12.2k
15
votes
5
answers
16k
views
Does it make sense to use SQL Server's bracket notation in hand written code?
Code generators tend to be simpler when they generate output using the new Microsoft bracket notation ([]) for nearly everything.
When I first saw it, I though wow a reincarnation of the somewhat ...
- 12.2k