Questions tagged [style]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
2 answers

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 SELECT * FROM (SELECT cities.* , ROW_NUMBER() OVER(PARTITION BY country ORDER BY ...
User1974's user avatar
  • 1,447
5 votes
2 answers

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 ...
bernd_k's user avatar
  • 12.2k
8 votes
2 answers

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 ...
bernd_k's user avatar
  • 12.2k
15 votes
5 answers

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 ...
bernd_k's user avatar
  • 12.2k