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 74 times
0
marc_s
- 732,580
- 175
- 1,330
- 1,459
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)` – Feb 13 '15 at 09:53