December 22, 2005 at 7:35 am
I was given the task of transforming all of my company's MS Access 2000 databases to SQL Server 2000. We have a number of instances where invalid identifiers were used when the columns were named. For example one table has columns named 1,2,3,4,5,6,7,8,9. Another table has columns named position, IJDB-SubSelection
Will this create a problem leaving these column names alone? The database serves as the backend to different websites accessed via asp.
December 22, 2005 at 7:51 am
I think you need to wrap square brackets around your invalid column names.
December 22, 2005 at 7:56 am
yes, they have the square brackets around them. My concern is will these cause a problem. I have renamed some of the columns because they used reserved words. I am wondering if it is ok to use the others or if I should just rename them and of course that means go through every asp page and alter the code.
December 26, 2005 at 9:48 am
If it were my database I'd go through and change the names of all of the offending columns. One never knows when SQL will serve up an 'undocumented feature' (bug) ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply