Selecting multiple columns in SQL

Question

I have a table with over a hundred columns, but I only want to select the the columns named nvarchar1, nvarchar2, ... nvarchar64. All of these 64 columns are next to each other so I was thinking maybe there is a way to select using column indices, but I couldn't find a solution.

Note: I don't want to do the obvious solution,

SELECT nvarchar1,
       nvarchar2,
       ...
       nvarchar64
...

What DBMS are you using? And have you ever come across the problem of "repeating groups" with respect to First normal form? If you can, a table redesign might help you more than anything else. — Peter Majeed
– Peter Majeed, Commented Jul 20, 2012 at 13:34
I think it's 2005 and I don't know what your second question means. — Kevin Cho
– Kevin Cho, Commented Jul 20, 2012 at 13:39
I'm going to take it you mean SQL Server 2005 (as opposed to Oracle, MySql, SQLite, etc.), so I'll retag the question as such. For my second question, if you haven't read much on database normalization, the article I linked to in my comment explains some problems you may encounter with repeating columns/groups. — Peter Majeed
– Peter Majeed, Commented Jul 20, 2012 at 13:42

Josien · Accepted Answer · 2012-07-20 13:47:10Z

3

Make use of the result from this query:

select  column_name + ','
from    information_schema.columns
where   table_name = 'your table name'
        and column_name like 'nvarchar%'

edited Jul 20, 2012 at 13:47

Josien

14k5 gold badges39 silver badges55 bronze badges

answered Jul 20, 2012 at 13:31

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

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

2 Comments

Kevin Cho Over a year ago

The result shows the names of the columns, but how do I use it in a select? Sorry, I'm still very new to sql.

Madhivanan Over a year ago

Copy the result and use it in your select statement

Collectives™ on Stack Overflow

Selecting multiple columns in SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related