为什么我应该将我的 SQL 关键字大写? [英] Why should I capitalize my SQL keywords?
本文介绍了为什么我应该将我的 SQL 关键字大写?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
简单的问题.我个人发现一串小写字符比一串大写字符更具可读性.一些旧的/流行的 SQL 是否区分大小写?
Simple question. I personally find a string of lowercase characters to be more readable than a string of uppercase characters. Is some old/popular flavor of SQL case-sensitive or something?
供参考:
select
this.Column1,
case when this.Column2 is null then 0 else this.Column2 end
from dbo.SomeTable this
inner join dbo.AnotherTable another on this.id = another.id
where
this.Price > 100
对比
SELECT
this.Column1,
CASE WHEN this.Column2 IS NULL THEN 0 ELSE this.Column2 END
FROM dbo.SomeTable this
INNER JOIN dbo.AnotherTable another ON this.id = another.id
WHERE
this.Price > 100
前者对我来说似乎更具可读性,但我更经常看到后者.
The former just seems so much more readable to me, but I see the latter way more often.
推荐答案
我觉得后者可读性更好.您可以轻松地将关键字与表名和列名等分开.
I think the latter is more readable. You can easily separate the keywords from table and column names, etc.
这篇关于为什么我应该将我的 SQL 关键字大写?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文