Cross Apply blocks "Tab to expand wildcard"
PawJ
Posts: 13 Bronze 1
Promt Version: 10.16.3.14709
We have this very simple code, were we cannot use the Tab to expand wildcard
Code Example:
Any ideer what we are doing wrong or is there a small bug ??
We have this very simple code, were we cannot use the Tab to expand wildcard
Code Example:
SELECT * FROM [sys].[indexes] [i] JOIN [sys].[stats] [s] ON [s].[object_id] = [i].[object_id] AND [s].[stats_id] = [i].[index_id] CROSS APPLY [sys].dm_db_stats_properties ([s].[object_id], [s].[stats_id]) [sp] WHERE [i].[object_id] > 999
When we put the cursor at the wildcard, we get the following suggestion ???:
If we move the mouse over, we see all the columns as expected!:
If we do an INTO #d for a temp table and hover over it, we get the following:
If we comment out the cross apply it seems to work:
Any ideer what we are doing wrong or is there a small bug ??
Tagged: