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

Question

I am trying to write a column name using ".". without success

Example:

SELECT PrmTable.Value = MAX(Value) FROM TempTable 

or

 SELECT MAX(Value) AS PrmTable.Value FROM TempTable 

Any idea?

Answer 1

Just enclose it in square brackets and it will work

eg.

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

Answer 2

I would not recommend that you use field names that always require you to enclose the name in parentheses, this becomes a pain.

Also, a period is used in SQL Server to denote schema and database name separators. Using your field name, the full field name will look like this:

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

This looks weird and is probably confused by other database administrators. Use underscore to separate words in field names; this is a much more common style:

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

Answer 3

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