I do not know if this is a bug or new code complete omission, but I believe code
complete is getting lost. I have reported this before, but now I can reproduce
it at will, meaning so can Quest.
Let me know if this has already been submitted, if not please create a CR for
same.
Please look at the graphic below, where I am working with a script
I wanted to put in à where NoOfRows but code complete just wanted to give me
@ and @@ variables.
Meaning it never/ever references the variable .
Script to create the problem
Script to create the temp table
select
SchemaName
,TableName, NoOfRows
from #hank_temp
WHERE --(this is where the error is located)
SELECT sys.schemas. name AS schema_name ,sys.objects. name ,
sys.objects.create_date, sys.objects.modify_date
Into #hank_temp
FROM sys.objects
INNER JOIN sys.schemas ON sys.objects. schema_id = sys.schemas.
schema_id
where sys.objects.type_desc = 'USER_TABLE' ;
Hank Freeman
Senior SQL Server DBA/Data & Systems Architect
678-414-0090 my cell Primary
hank.freeman50 via Skype