Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohit.piscean
Starting Member
1 Post |
 Posted - 2008-05-26 : 03:53:54
|
| HI All,can we interchange the column position in sql. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 03:58:36
|
| You shouldnt really worry about this as you can always retrieve columns in whatever order you want by specifying them in your SELECT statement. |
 |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-05-26 : 05:38:38
|
| An alternative solution:Create a view with the columns in required order.Suresh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 05:41:46
|
quote:
Originally posted by suresha_b
An alternative solution:Create a view with the columns in required order.Suresh
Is a view necessary when you want nothing else rather than changing order of column retrieval? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-05-26 : 14:18:40
|
| No you can do it in the select statement.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
can we interchange the column position in sql