I created the view View_DefectDaysOutstanding3. when I select to see the data, it gives the data, but why in the select statement all the fields are underlined in red as error?
SELECT TOP 1000 [ID] ,[Severity] ,[AvgDaysOutstanding] ,[ReportMonth] ,[ReportYearMonth] ,[#OfBugs] ,[projid] ,[folderid] FROM [SoftwarePlanner].[dbo].[View_DefectDaysOutstanding3] order by ReportYearMonth
Try pressing ctrl + Shift + r to refresh intellisense and remove the red squiggly underline.
A column name should describe what's in the column. One of the simplest ways to solve an “ambiguous name column” error — without changing column name — is to give the tables you want to join an alias. This sends a clear information to the SQL Machine the columns are different.
Click Options on the Tools menu. Click Environment, and then click Fonts and Colors. In the Show settings for list, select Text Editor. Change the font, size, display item, foreground and background colors.
Have you refreshed your Intellisense cache?
Keyboard shortcut: Ctrl + Shift + R
Or, using the menu: Edit
-> IntelliSense
-> Refresh Local Cache
Go to Edit > IntelliSense > select "Refresh Local Cache".
You need to refresh your cache after you create new tables/add columns/ new views etc
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With