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-08-16 : 09:26:19
|
| Ravi writes "Dear SQL Guru,Is there is any way to insert a column between 2 already exists columns in a table through T-SQL statement ... ?" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-16 : 09:31:57
|
| Why you want it? Physical order of the columns within the table is unimportant. Doing this is not straight-forward in SQL server and not good performance wise either. The easiest way is to do it thru Enterprise manager, but I highly recommends against doing this on production server.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-16 : 09:32:38
|
| try to insert the same using EM and then generate the script from EMChirag |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-16 : 12:20:34
|
| Ordinal position of the column in a table doesnt matter as long as you use them in proper position in select statementMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Sql Table