What are the challenges you face when working across database platforms? Take the survey
Options

Improvement for insert statement.

EsioNEsioN Posts: 103
edited July 20, 2007 7:28AM in SQL Prompt Previous Versions
When typing insert dbo.xxx, it'g greath when SP3.5 show me the column list and the values (/* type */ default_value).
Can be more usefull if, with the /* type */ SP brings me also the column name. Especially with tables with a lot of columns.

Thanks

Ésio

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Esio,


    Thanks for the suggestion, that's a good idea. If you have a table with 20 columns in at the moment it's easy to lose track of which column you're entering a value for. We won't add this for the 3.5 final release because it's getting quite late in the day and so we're only now fixing critical problems, however we'll certainly consider this enhancement for the next patch release.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.