identity column does not show on auto-completed INSERT

pugv

i type in

insert TableName, then auto-complete the column list - the identity column is missing from the list.

-- can't find a setting in the options for this.


thanks.

tanya

Hi,

SQL Prompt used to list the identity columns while choosing to auto-complete insert statements in the previous versions. However, since identity columns are usually auto-generated values many of our users thought it would be better if that was not listed in the auto-completion list which led to the current implementation!

Thanks,
Tanya

pugv

thanks for the reply tanya.

seems you've appeased one set of customers, but inconvenienced the other half

wouldn't this be better as a user option?

tanya

We did think of options but the trouble is SQL Prompt has loads of options and users tend to get confused having to navigate through such vast option items.

We are now planning for our next version and it’s too early to promise anything at this stage. But I will log your suggestion into our database and keep you posted with the updates

Thanks,
Tanya

MikeyC

Or could SQL Prompt look to see if the IDENTITY INSERT option is turned on for that table, and if so include the IDENTITY column.

Michael

EsioN

There is a gap.
When typing the insert for existent tables, the SP3.8 doesn't bring the identity colum (and I'm happy for this), but if you create a new table and type the insert command, so SP3.8 will mount the insert command based on the create table script, it brings the identity column.

Regards,

Esio

jerryhung

I am fine with not showing IDENTITY column during an insert :P

At least if one needs to insert manually into that column, they have to do some work (add in the column name, set identity insert on/off, etc...), intentionally