|
|
Posted by Tom van Stiphout on 11/22/07 17:54
On Thu, 22 Nov 2007 05:29:16 -0800 (PST), Yoda <rmotto@teaminf.com>
wrote:
SQL Server recognizes the [field name] syntax as well, so you could
rename those fields (see Alter Table).
-Tom.
>Hi,
>i'm working on a project for convert from a mdb AccessXP(2002)
>application backend to SQL Server Express 2005.
>
>In the past i convertend a similar backend to SQL Server 2000.
>
>My problem is: I have many fields on mdb backend with spaces in field
>name (i know bad thing)
>
>With SQL Server 2000 I had no problem because it recognize the field
>correctly with syntax [field name]
>
>but now with SQL Server Express 2005 i'm experiencing problems....in
>fact it wants to write the field in this way 'field name'.
>
>Now...what do u suggest me?
>
>Go back to SQL Server 2000 or change all the field names? this is
>because with the character ' apex i have many problem in SQL syntax.
>
>Thank u in advance
>
>Bye
>Rob
Navigation:
[Reply to this message]
|