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
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
SchemaName ,TableName, NoOfRows
WHERE --(this is where the error is located)
SELECT sys.schemas. name AS schema_name ,sys.objects. name ,
FROM sys.objects INNER JOIN sys.schemas ON sys.objects. schema_id = sys.schemas.
where sys.objects.type_desc = 'USER_TABLE' ;
Senior SQL Server DBA/Data & Systems Architect
678-414-0090 my cell Primary
hank.freeman50 via Skype