I want to select columns in a table in SQL Server by there index.
Something like
SELECT column1 TO column5
FROM Table1
Is there any method like above or any other idea to achieve this?
Asked
Active
Viewed 72 times
0
marc_s
- 704,970
- 168
- 1,303
- 1,425
Govind Sharma
- 29
- 1
- 9
-
2NO! You have to specify the column names. – Felix Pamittan Feb 13 '15 at 05:30
-
so i have specify each column name in statement for selection? – Govind Sharma Feb 13 '15 at 05:36
-
Note that in a relational database columns don't really have an index. `create table (a int, b int)` is conceptually the same as `create table (b int, a int)` – a_horse_with_no_name Feb 13 '15 at 09:53