How to write a column name with dot (".") in the SELECT clause?

Question

I'm trying to write a column name using "." with no success

sample:

SELECT PrmTable.Value = MAX(Value) FROM TempTable

or

SELECT MAX(Value) AS PrmTable.Value FROM TempTable

Any idea ?

try enclosing it in double quotes - SELECT MAX(Value) AS "PrmTable.Value" — d-live
– d-live, Commented Apr 12, 2011 at 11:37

AdaTheDev · Accepted Answer · 2011-04-12 11:36:59Z

30

Just enclose it in square brackets, and it will work

e.g.

SELECT MAX(Value) AS [PrmTable.Value] FROM TempTable

answered Apr 12, 2011 at 11:36

148k28 gold badges215 silver badges204 bronze badges

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

Comments

Tony · Accepted Answer · 2011-04-12 11:43:11Z

I would not recommend you use field names which always require you to enclose the name in brackets, it becomes a pain.

Also the period is used in SQL Server to denote schema and database name separators. Using your field name the full name for a field becomes:

[DatabaseName].[SchemaName].[TableName].[FieldName.WithPeriod]

That just looks odd and would probably confuse other DBAs. Use an underscore to separate words in your field names, it's a much more common style:

[DatabaseName].[SchemaName].[TableName].[FieldName_WithUnderscore]

Akram Shahda · Accepted Answer · 2011-04-12 11:37:47Z

3

SELECT [PrmTable.Value] = MAX(Value) FROM TempTable or SELECT MAX(Value) AS [PrmTable.Value]

answered Apr 12, 2011 at 11:37

14.7k5 gold badges46 silver badges67 bronze badges