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 - 2000-10-04 : 13:45:41
|
Ville writes "I want to create an ASP that checks if table B has all the same columns that table A does, and if not, it will insert the missing columns to table B.
Okay, so that isn't too tricky, but the problem is that the new columns should be inserted into the same places that the original ones are in, ie. if column 'Prices' is third in table A, it should, if missing from table B, be inserted as the third column in table B.
So I'm wondering if there's some kind of internal id or something like that in SQL that I could use?
" |
|
|
|
|
|
Inserting columns with a specific position