Computed columns and SQL prompt

danboc

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

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.

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

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.