How do I add a bit column on the fly

Last post 09-26-2008, 9:42 AM by Phil Factor. 1 replies.
Sort Posts: Previous Next
  •  09-24-2008, 9:05 PM Post number 69706

    How do I add a bit column on the fly

    I want to add a bit column that is not in the database but will be used in the interface something like

    select colunm2, [bit] as printid from tblprojects where id > 1

  •  09-26-2008, 9:42 AM Post number 69724 in reply to post number 69706

    Re: How do I add a bit column on the fly

    when you say that you want to add it 'on the fly', does that mean that you want to put an extra field into a table and remove it during a routine of some sort? Adding columns to tables 'on the fly' is an interesting idea..

    to add a column, try...

    ALTER TABLE  tblObjects ADD
          
    [printid] BIT

View as RSS news feed in XML