sql语句中方括号[]有什么用? [英] What is the use of the square brackets [] in sql statements?

问题描述

我注意到 Visual Studio 2008 将方括号放在 sql 中的列名周围.括号有什么好处吗?当我手动编写 T-SQL 代码时，我从不理会它们.

I've noticed that Visual Studio 2008 is placing square brackets around column names in sql. Do the brackets offer any advantage? When I hand code T-SQL I've never bothered with them.

例子:

Visual Studio:

Visual Studio:

SELECT [column1], [column2] etc...

我自己的方式:

SELECT column1, column2 etc...

推荐答案

如果在列名或标识符中使用关键字或特殊字符，则需要括号.您可以将一列命名为 [First Name](带有空格)，但每次引用该列时都需要使用方括号.

The brackets are required if you use keywords or special chars in the column names or identifiers. You could name a column [First Name] (with a space) – but then you'd need to use brackets every time you referred to that column.

新的工具将它们添加到任何地方以防万一或保持一致性.

The newer tools add them everywhere just in case or for consistency.

这篇关于sql语句中方括号[]有什么用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！