Re: order of columns

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

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 10/05/04 

Date: Wed, 06 Oct 2004 01:40:28 +0200

On Tue, 5 Oct 2004 09:59:01 -0700, Bonj wrote:

>OK, so it's an absolute load of b*&&@%£s that it works at all then, even with
>sysadmin?

Hi Bonj,

The code in your post worked. Adding one row of data before the alter
table but no changing anything else, it still works. But if you remove the
identity property of the added column as well, it corrupts the data in the
table.

I didn't play around with it for long enough to find out why it does work
in some cases. I had expected it to trash your data in all situations.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Re: Disabling a trigger
    ... ALTER TABLE tablename ... Best, Hugo ... (Remove _NO_ and _SPAM_ to get my e-mail address) ...
    (microsoft.public.sqlserver.programming)
  • Re: how to add new column like existing one?
    ... On Sat, 29 Jan 2005 21:44:12 GMT, AFN wrote: ... ALTER TABLE MyTable ... Best, Hugo ... (Remove _NO_ and _SPAM_ to get my e-mail address) ...
    (microsoft.public.sqlserver.programming)
  • Re: Moving the Movie Maker Project folder
    ... DavidSitner wrote: ... BTW...when posting in newsgroups... ... to prevent unwanted spam... ... be a good idea to alter your return ...
    (microsoft.public.windowsxp.video)
  • Re: New Words (was: some word usage)
    ... asked readers to take any word from the dictionary, alter it by ... adding, subtracting, or changing one letter, and supply a new ... If your message looks like spam I may not see it. ...
    (alt.usage.english)
  • Re: Best way to force a varchar column to have no whitespace
    ... Yes, thanks for the catch, Hugo. ... ADD CONSTRAINT CK_Table1_Col1 ... ALTER TABLE MyTable WITH CHECK ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)