Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unuseable Field Name in Database Expand / Collapse
Author
Message
Posted Friday, May 29, 2009 7:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:01 PM
Points: 75, Visits: 209
I have tried to bring it in to Visual Sudio as is, and with an underscore where the space is.
It does not recognize it as a database field.
Any ideas???

Thank you.
Post #725774
Posted Friday, May 29, 2009 7:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:01 AM
Points: 10,282, Visits: 13,266
If object names have a normally disallowed character in them you either need to turn on quoted identifiers and use double-quotes (") around the name, "First Name", or you can just use brackets, [First Name].



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #725788
Posted Friday, May 29, 2009 7:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:01 PM
Points: 75, Visits: 209
Thank you.
It works both ways. Just like you said.
Post #725797
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse