How to eliminate the red wavy lines of SQL Server 2008 query statements

Source: Internet
Author: User
Tags management studio microsoft sql server management studio sql server management studio

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.