I have a Location table in my OLTP which, while coding SSIS against it, I found a LocationCode column name to have a trailing space in it.
Create Table Location
(
[LocationId] INT IDENTITY (1, 1)
[LocationCode ] INT
)
Note that LocationCode column name has a trailing space.
And yet, the following code works.
SELECT LocationCode
From Location
As a matter of fact, we located several places where the trailing space is used in stored procs, and it has continued to work.
How is this possible?