Problem select specific column name using sql statement

Question

I found problem when trying to retrieve specific name column that using syntax/statement/command using sql.

Example I have table 'dcparam' with name some column 'SELECT', 'INSERT', 'UPDATE' in database sqlserver. Then I trying to select using query:

SELECT SELECT,INSERT,UPDATE FROM dcparam

Well it could be solve using "*" in select, but then how if i wish only specific column.

Regard.

Jaymz · Accepted Answer · 2010-10-18 08:34:23Z

5

Add square brackets around the column name.

SELECT [SELECT], [INSERT], [UPDATE] FROM dcparam

It's probably best to reconsider your column names in the long run however...

answered Oct 18, 2010 at 8:34

Jaymz

6,3982 gold badges29 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Sansom Over a year ago

+1: Agreed. And to re-iterate the posters comment for additional emphasis, you really must look to remove the use of reserved keywords as column names.

Collectives™ on Stack Overflow

Problem select specific column name using sql statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related