When I learned SQL recently, I used SQL Server 2008.
This version has a good place to be smart tips, but this smart hint sometimes it is very annoying,
For example, after creating a new data table, the table is named person
When using structured query statements, the input person always appears with a wavy red line (red wavy lines are usually a hint of error, but this is true)
There is a good explanation on Baidu:
The list of fields for this table lets you choose. However, when you create a new object, such as a table, or your example, is the new stored procedure ABC this time, the database there, there is already stored process ABC. But inside the client's cache, there is no information stored in the process ABC. Because the information inside the memory is not updated. So, at the client there. The input exec abc,abc has a red line. After the client is shut down, reopen the database because the client reloads the underlying information. You know, in the current database, there's a stored procedure named ABC.The red line is out.
I see a good way on the Internet:
Click "Edit"--"IntelliSense"--"refresh local cache" in Microsoft SQL Server Management Studio
You'll find that the red wavy line is gone (assuming your code is correct)
This article from "Saab √ Martini" blog, declined reprint!
How to eliminate the red wavy lines of SQL Server 2008 query statements