[] braces

what r the used for?
what is the difference bitween [CustomerID] and CustomerID
thanksSo that you can use keywords and spaces in field names
example
[Customer ID] and [Order]
http://sqlservercode.blogspot.com/
Fred wrote:
> what r the used for?
> what is the difference bitween [CustomerID] and CustomerID
> thanks|||Words surrounded by braces are called "delimited identifiers", and you can
use them to embed things like spaces and other characters that break the
rules. For instance:
CREATE TABLE [My Table]
(
[My Column] INT
)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Fred" <fred@.ilovespam.com> wrote in message
news:%23FiWJ2UEGHA.472@.TK2MSFTNGP12.phx.gbl...
> what r the used for?
> what is the difference bitween [CustomerID] and CustomerID
> thanks