SQL Server Forums - Selectin strange column names

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums

Profile | Active Topics | Members | Search | Forum FAQ

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

Selectin strange column names

Reply to Topic

Printer Friendly

Author

Topic

deathrone
Starting Member

Poland
15 Posts

Posted - 06/10/2013 : 03:30:46

The column in the table is called <nr_ref,id>
how to select it ?

trololoolo

webfred
Flowing Fount of Yak Knowledge

Germany
8781 Posts

Posted - 06/10/2013 : 03:32:43

put the column Name between [].

select [nr_ref,id] from table

Too old to Rock'n'Roll too young to die.

bandi
Flowing Fount of Yak Knowledge

India
2242 Posts

Posted - 06/10/2013 : 03:33:52

SELECT [nr_ref,id]
FROM YouTable

--
Chandu

deathrone
Starting Member

Poland
15 Posts

Posted - 06/10/2013 : 04:00:25

thx !

trololoolo

deathrone
Starting Member

Poland
15 Posts

Posted - 06/10/2013 : 04:28:09

oh but, how to do it in ORACLE ?

trololoolo

bandi
Flowing Fount of Yak Knowledge

India
2242 Posts

Posted - 06/10/2013 : 04:53:26

quote:
Originally posted by deathrone

oh but, how to do it in ORACLE ?

trololoolo

I think you can use double quotes in oracle
SELECT "nr_ref,id"
FROM TableName

--
Chandu

Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.