Variable names in SQL Server

Question

Can I declare name of SQL Server variable in a table with spaces?

create table test(
record name, float, not null
.....

The above query when executed gives me an error. Is there any way to declare the variable as variable name with a space..??

Mahmoud Gamal · Accepted Answer · 2013-08-19 09:26:34Z

8

Yes, escape these names using []:

[record name] ....

These names are called Delimited identifiers:

Are enclosed in double quotation marks (") or brackets ([ ]).

But it is not recommended, use legal names instead or regular identifiers.

answered Aug 19, 2013 at 9:26

Mahmoud Gamal

80.3k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ok but i uploaded excel files into the server and those have spaces . Its either this or renaming many records. Thanks...

Lucian · Accepted Answer · 2013-08-19 09:27:37Z

1

Try using square brackets:

create table test(
[record name] float not null)

answered Aug 19, 2013 at 9:27

Lucian

4,0015 gold badges32 silver badges34 bronze badges

Chris · Accepted Answer · 2013-08-19 09:27:42Z

0

use [square brackets] around your column names with spaces and you should be fine.

It would be advisable in the long term to avoid spaces all together if you can, it will save you hours of stress in the future.

answered Aug 19, 2013 at 9:27

Chris

2,9381 gold badge33 silver badges45 bronze badges