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

Stop qualifying column names for updates

OsolageOsolage Posts: 15
edited September 4, 2008 9:48PM in SQL Prompt Previous Versions

Every time I write an update statement SQL Prompt fully qualifies the update columns, but I don't want it to. How can I stop this?

For example:
UPDATE [dbo].[X]
SET [TargetValue]

UPDATE [dbo].[X]
SET [dbo].[X].[TargetValue]

I'm used to listing the update columns without qualifying them. Can that be stopped somehow?
Ra Osolage


  • Options

    I am sorry but there is no specific setting to turn off 'qualify columns' for specific statements.
    Enabling 'Qualify column names' will qualify the columns in all statements.

    However, I will include this as a feature request and we will review this for our future versions.

  • Options
    I've just encountered this one too, in v3.9 against SQL2k.

    It really only makes sense to have the columns qualified in places where an expression is allowed. There is no need to qualify the column names in the SET clause of an UPDATE statement, as there is no ambiguity over which column is the target. The same goes for the column list in an INSERT statement. While it appears that it is valid syntax, it does seem unnecessarily verbose.
Sign In or Register to comment.