[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Column Position in Table

vovan

3/19/2007 6:41:00 PM

I need to alter a table in many instances of the same database - many
clients use the same structure of the database.
I wrote the script:

ALTER TABLE [dbo].[TakeOffSummaryItem] ADD
[ListPrice] [money] NULL ,
[DirectCommissions] [money] NULL ,
CONSTRAINT [DF_TakeOffSummaryItem_ListPrice] DEFAULT (0) FOR
[ListPrice],
CONSTRAINT [DF_TakeOffSummaryItem_DirectCommissions] DEFAULT (0)
FOR [DirectCommissions]

I works fine. Now I'd like to move new columns from the end of the table
somewhere between other existing columns.
How can I do that?

vovan
1 Answer

Enviromentally Whacko

6/19/2008 8:29:00 PM

0


"What Me Worry?" <__@____.___> wrote in message
news:kqednRdKi_9SM8fVnZ2dnUVZ_jSdnZ2d@comcast.com...
>
> "Lamont Cranston" <Lamont.Cranston@penumbra.com> wrote in message
> news:g3e782$sk4$1@news.datemas.de...
>> Harry Dope wrote:
>>> Urgent: House Democrats call for nationalization of refineries
>>
>> Nazis? ROTFLMAO!
>>
>> Uh, Dope. The Nazi Party never nationalized industry. Nationalization
>> of industry is an ultra-leftwing policy. The Nazis were ultra-rightwing.
>>
>> "Why nationalize industry when you can nationalize the people?" -- Adolf
>> Hitler
>
> Could these desperate, flailing, morally-bankrupt, party-before-country
> repug traitors be any more ignorant?
>
> But what would you expect from people dumb enough to support the Bush
> regime?
>====================

Notice the liberal socialist fascist did'nt say the US has no business
federalizing private industry.