Re: Inserting a column in the middle of a table using Transact SQL
From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 08/13/04
- Next message: Aaron [SQL Server MVP]: "Re: xp_cmdshell: Filename created dynamically"
- Previous message: Aaron [SQL Server MVP]: "Re: Date Problem"
- In reply to: Don Miller: "Inserting a column in the middle of a table using Transact SQL"
- Next in thread: Lisa Pearlson: "Re: Inserting a column in the middle of a table using Transact SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 12 Aug 2004 22:23:31 -0400
No, T-SQL doesn't allow this directly, and I'm not sure why this request is
so common.
http://www.aspfaq.com/2528
-- http://www.aspfaq.com/ (Reverse address to reply.) "Don Miller" <millerdf@hotmail.com> wrote in message news:#hucSENgEHA.140@TK2MSFTNGP12.phx.gbl... > Assuming that I have a table with columns A, B and C in that order, how can > I add a new column called D between A and B from an SQL script? > > Thanks! > dm. > >
- Next message: Aaron [SQL Server MVP]: "Re: xp_cmdshell: Filename created dynamically"
- Previous message: Aaron [SQL Server MVP]: "Re: Date Problem"
- In reply to: Don Miller: "Inserting a column in the middle of a table using Transact SQL"
- Next in thread: Lisa Pearlson: "Re: Inserting a column in the middle of a table using Transact SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|