查询中的表名是否不区分大小写？

I have read the following article. They have quoted that,

我已阅读以下文章。他们引用了这个,

SQL Server is a case-sensitive back-end application. This means that a table named "addr" is distinguished from a table named "ADDR." However, because Microsoft Query is an MS-DOS-based application, it is unable to distinguish cases; therefore, Microsoft Query views "addr" and "ADDR" as the same file.

SQL Server是一个区分大小写的后端应用程序。这意味着名为“addr”的表与名为“ADDR”的表区分开来。但是,由于Microsoft Query是基于MS-DOS的应用程序,因此无法区分案例;因此,Microsoft Query将“addr”和“ADDR”视为同一文件。

Now I wanted to know what to they mean by case-sensitive back-end application? Is it safe to use the query with case-insensitivity?

现在我想知道区分大小写的后端应用程序意味着什么?使用不区分大小写的查询是否安全?

Thanks in advance.

提前致谢。

1 个解决方案

#1

SQL Server with default collation will return you the same result, doesn't matter which case you use for your query.

具有默认排序规则的SQL Server将返回相同的结果,无论您使用哪种情况进行查询。

Collation can be set at various levels

可以在各种级别设置整理

Server
Database
Column

For more info can be found out here

欲了解更多信息,请点击此处

Please check Applies To section of the article you referenced. KB article applies to product from Microsoft for which they no longer provide any support.

请检查您引用的文章的“适用于”部分。知识库文章适用于Microsoft不再提供任何支持的产品。

#1