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 10:29 pm

If the snippet below is run through SQL Prompt 6.2.0.366'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.
JDS44
 
Posts: 5
Joined: Fri Sep 20, 2013 10:11 pm

Postby Aaron Law » Wed Mar 26, 2014 5: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.
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 1 guest