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 |
|
glpita
Starting Member
17 Posts |
 Posted - 2010-08-04 : 10:48:10
|
| Hi all,I need to add 3 columns (with zeros in them) to a preexisting table between the 3rd and 4th columns. How can I do this? Thanks a lot, |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-04 : 10:50:55
|
It is only possible to create a new table with the wanted order of columns.Otherwise the new columns will be added to the end.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-08-04 : 10:58:17
|
quote:
Originally posted by glpita
Hi all,I need to add 3 columns (with zeros in them) to a preexisting table between the 3rd and 4th columns. How can I do this? Thanks a lot,
Why does the order matter? You can add them at the end and SELECT the data in any order you want |
|
|
|
glpita
Starting Member
17 Posts |
Posted - 2010-08-04 : 12:13:22
|
| Alright, thank you very much.. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-09 : 04:53:27
|
| Also in your application, you should refer recordset object by column name like rs("col") rather than rs(0), this way you dont need to worry about the actual position of the columnMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Add a new column between chosen columns