SQL Select Question

[Rob Panosh]

Hello,

This is probably a stupid question but I am going to ask it anyway because I
don't know the answer to it. Both SQL Select Statements, below, execute and
retuurn the same results. Why would on put the [ around the table and
column names?

SELECT Customer.FirstName FROM Customer
or
SELECT [Customer].[FirstName] FROM [Customer]
Thanks,
Rob Panosh

[Makjalele]

brackets are used when table/column names contain spaces or keywords.in
other cases brackets may be used also but also could be avoided.
"Rob Panosh" <ro************************@asdsoftadfdware.com> wrote in
message news:3f******@news.splitrock.net...

Hello,

This is probably a stupid question but I am going to ask it anyway because I don't know the answer to it. Both SQL Select Statements, below, execute and retuurn the same results. Why would on put the [ around the table and
column names?

SELECT Customer.FirstName FROM Customer
or
SELECT [Customer].[FirstName] FROM [Customer]
Thanks,
Rob Panosh

[David Portas]

See the following topic from Books Online:
http://msdn.microsoft.com/library/en...on_03_6e9e.asp

In your example the delimiters are not essential since the names don't
include special characters or reserved words. However, using the delimiters
protects your code against the possibility that a name used as an identifier
may be declared a reserved word in a future version of SQL Server. That's
not likely for words like "Customer" but in the interests of a common style
and good programming practice this style may be adopted for all identifiers.
As with any aspect of coding style, different developers have different
preferences and practices.

The ANSI standard delimiter is to use double quotes which works in TSQL
assuming the QUOTED_IDENTIFIER option is ON. [] is an alternative notation
used in Access and SQLServer.

--
David Portas
------------
Please reply only to the newsgroup
--

[Rob Panosh]

David,

Thank you for the explanation.

Rob

"David Portas" <RE****************************@acm.org> wrote in message
news:ga********************@giganews.com...

See the following topic from Books Online:
http://msdn.microsoft.com/library/en...on_03_6e9e.asp

In your example the delimiters are not essential since the names don't
include special characters or reserved words. However, using the delimiters protects your code against the possibility that a name used as an identifier may be declared a reserved word in a future version of SQL Server. That's
not likely for words like "Customer" but in the interests of a common style and good programming practice this style may be adopted for all identifiers. As with any aspect of coding style, different developers have different
preferences and practices.

The ANSI standard delimiter is to use double quotes which works in TSQL
assuming the QUOTED_IDENTIFIER option is ON. [] is an alternative notation
used in Access and SQLServer.

--
David Portas
------------
Please reply only to the newsgroup
--

[Rob Panosh]

Makjalele,

Thanks ....

Rob

"Makjalele" <st******************@net.hr> wrote in message
news:br**********@ls219.htnet.hr...

brackets are used when table/column names contain spaces or keywords.in
other cases brackets may be used also but also could be avoided.
"Rob Panosh" <ro************************@asdsoftadfdware.com> wrote in
message news:3f******@news.splitrock.net...

Hello,

This is probably a stupid question but I am going to ask it anyway

because I

don't know the answer to it. Both SQL Select Statements, below, execute

and

retuurn the same results. Why would on put the [ around the table and
column names?

SELECT Customer.FirstName FROM Customer
or
SELECT [Customer].[FirstName] FROM [Customer]
Thanks,
Rob Panosh