How can we help you today? How can we help you today?

Computed columns and SQL prompt

Hi,

I guess this is a bug/feature request:
When SQL prompt expands an INSERT INTO command, it includes computed columns in the field list and the value list. As these fields cannot be updated there is no need to include them in an INSERT INTO statement.

Thanks,

Daniel
danboc
0

Comments

3 comments

Sort by
  • Linda Hawksworth
    I have logged a bug against SQL Prompt in our tracking system with reference SP-2907. It will be considered for a future release of SQL Prompt although we have no timescales for this at present.
    Linda Hawksworth
    0
  • mscheuner
    I agree - having computed columns in the list of fields of an expanded INSERT statement makes no sense at all.

    Same goes for columns of type TIMESTAMP or ROWVERSION - one can never insert a value into those - so why put them in the list of fields of an INSERT statement in the first place??
    mscheuner
    0
  • mscheuner
    This issue seems to have been fixed with this new cummulative patch release:

    http://www.red-gate.com/MessageBoard/vi ... hp?t=10248

    At least in my cases, everything works as expected now, with this new patch version.
    mscheuner
    0

Add comment

Please sign in to leave a comment.