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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-07 : 08:23:21
|
| Amit writes "how Can i ADD a Column To an Existing table At Specified Location Using T-SQL, Like I Have a Table Having 5 fields.. I Want To Add My Column After First Column.." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-07 : 08:27:37
|
| Ordinal Postion of the column in the table doesnt matter. In your select query you can have that column at the preferred position. Also in your application, dont use rs(0), rs(1), etc. Use rs("col1"),rs("col2") etc. Otherwise make use of Enterprise Manager which actually drop the table and create new column at the preferred positionMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Add Column