in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last
This is a discussion on in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:55 PM
| ||||
| ||||
 in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last      |
|
02-27-2008, 07:55 PM
| ||||
| ||||
| Re: in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last Daniel wrote: > in sql server 2000 when you issue a alter table to add new column, can you > specifiy the order? meaning i want that column to be between existing > columns, not at the last There is no T-SQL syntax to do so, unless you drop and recreate fields in the order you wish for (in which case you lose data). |
 |
« Too many columns found in the current row; non-whitespace characters were found after the last defined column's data.
|
retrieve Primary key value from OLAP Cube »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:00 AM.
