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 |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2009-11-25 : 01:46:31
|
| for adding column i usealter tablename add newcolumnname datatypeits getting added as last column only, but i want to add as second column.how to do this subha |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-11-25 : 01:57:21
|
| Hiusing query Currently is not possible.you can use Enterprise Manager or Management Studio tomake this modification (which recreates the table and copies the data,a pretty dangerous thing to do in a production environment) -------------------------R... |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-25 : 02:53:51
|
quote:
Originally posted by subhaoviya
for adding column i usealter tablename add newcolumnname datatypeits getting added as last column only, but i want to add as second column.how to do this subha
Why does the ordinal postion of the column matter?You can use it at the position you want in the select statementMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
how to add column after specified column in sql?