Re: Inserting a column in the middle of a table using Transact SQL

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 08/13/04


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.
>
>


Relevant Pages

  • RE: Dominican Republic
    ... "D.S.Smith, LD Miller and JY Miller 1994, Butterflies of the West Indies ... and South Florida also covers the West Indies, but is not a field guide. ... Anyone can get a list of common names ...
    (sci.bio.entomology.lepidoptera)
  • To the USA ruggers out there
    ... Please find below a communication from the Potomac Rugby Union, and the Potomac Society of Rugby Fooball Referees. ... I would like to thank the PRU and PSRFR for their support and compassion for Todd, his mother Elie Miller, and his teammates of the Longwood Mens and Womens Rugby Clubs. ... I would like to extend their request to the Virginia Rugby Union clubs, and the whole of MARFU, and additionally request that USARFU send this request across the United States, and farther. ... On Saturday March 1, 2008, Todd Miller of the Longwood University ...
    (rec.sport.rugby.union)
  • Re: an old, apparently unanswered, question
    ... > works) then open a browser and request the page. ... Put this in a common "modlisp.lisp" file: ... and use (load "modlisp.lisp"). ...
    (comp.lang.lisp)
  • Re: Frustration with lack of ability to get warranty work done by Miller authorized service centers.
    ... > dealer on day one, instead of using the Miller RTQ page. ... They then pass the request on to the selected dealer. ... Hey, who knows, you ...
    (rec.crafts.metalworking)
  • Re: Q: Die Break = VAM?
    ... These are very common but interesting. ... the reverse but also in the obverse stars. ... Some desirable multiple clashes exist. ...
    (rec.collecting.coins)