Post reply

Does the text field have to be the last column on the table?

  • February 16, 2006 at 8:16 am

    #116304

    Someone told me that if you have a field in your SQL server database that is datatype of Text that it has to be the last field in the table.  This sounds very strange and wrong to me.  Couldn't find an anser on it, any ideas.

     

    Thanks

     

    e...

  • February 16, 2006 at 10:26 am

    #621423

    It is wrong. Text, ntext, and image columns can appear anywhere within the list of columns.

    Philip

  • February 16, 2006 at 8:25 pm

    #621530

    Yeah, thats what I thought.  Thanks.

  • February 17, 2006 at 6:55 am

    #621638

    Just to throw in the misconcept possibly is a hold over from a flaw early in ADO where blob fields needed to be at the end of the recordset sturucture or you wouldn't be able to see them. As for storage it doesn't matter simply because the data (unless you use the inline function in 2000) does not exist in the table, only a pointer to the location does.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply