Qualify object names not working with temporary tables

Provides intelligent code completion for SQL Server editors.

Qualify object names not working with temporary tables

Postby JDS44 » Tue Mar 25, 2014 9:29 pm

If the snippet below is run through SQL Prompt's Qualify Object Names process it highlights the two table names and the column name with unable to resolve errors.

Code: Select all
CREATE TABLE #OverrideMonth (OverrideMonth INT)
SELECT OverrideMonth FROM #OverrideMonth om

Is this expected behavior?

If so is there any good way to see the list of items that have problems that I can maintain since I working on a 3000 line procedure that when I edit it to manually fix them all the underlined issues dissapear and I have to re-run and re-find the areas to hand fix.
Posts: 5
Joined: Fri Sep 20, 2013 9:11 pm

Postby Aaron Law » Wed Mar 26, 2014 4:33 pm

Hi JDS44,

This looks like a bug to me, thanks for reporting it. I found a similar issue in our bug tracking system as SP-3198 which has been around for a while unfortunately. We have some work planned on revamping the qualify object names feature for the next version of SQL Prompt and I'll make sure that this gets fixed as part of that.

Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 3 guests