SQL Query

Apr 11, 2009 3 Replies
N

Hi All,



I know this isn't really RMS specific, but I've only encountered it in the RMS database.



How do you query the tables that include an SQL function in the name. For example, the table "dbo.Order" does not work for me because "order" is an SQL function. Is there some sort of escape character I should be using?



Is this just because I am using SQL management studio?



Thanks, Nate


Vote
Twitter Facebook LinkedIn
A

Use dbo.[Order] or [dbo].[Order] ...

you can use brackets to specify objects (columns, tables, views..)

Vote
Twitter Facebook LinkedIn
N

thank you antonio. I knew it was something like that but I couldn't figure it out.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required