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 |
|
webweaver
Starting Member
1 Post |
 Posted - 2007-06-13 : 16:56:54
|
| I have a table and I need to add a field to a specific spot in the table between to records. Since someone else has created stored procedures that need this field to be in spot 7 of 11 in the table.Is there an easy way to do this through a script? This change has to go out to many customers.Any help would be great, thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-13 : 16:58:25
|
| order of columns is irrelevant.you can just as easily add it to the end._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-06-13 : 21:50:34
|
| >> Since someone else has created stored procedures that need this field to be in spot 7 of 11 in the table.Yikes! If someone is writing stored procedures that rely on column positions to work (i.e., INSERT statements without explicitly specifying columns) then THAT is what you need to fix, not your database schema ! Never "fix" the part that is not broken so that the broken part works!- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
|
|
|
Adding a field to a table