Intellisense在SQL Server 2014中不起作用 [英] Intellisense is not working in SQL Server 2014

问题描述

Intellisense在Microsoft SQL Server 2014中无法正常运行，在Microsoft SQL Server 2012中可以正常运行，但是一旦我安装2014，它就无法正常运行.

Intellisense is not working in Microsoft SQL Server 2014, it was working fine in Microsoft SQL Server 2012 but once I installed 2014 it is not working.

在Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense下，它表示已在此处启用.

Under Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense it says it is enabled there.

我也尝试过使用Ctrl-Shft-R刷新IntelliSense缓存，但这是行不通的.

I have also tried refeshing the IntelliSense cache with Ctrl-Shft-R but that doesn't work.

推荐答案

从我的个人经验来看，SSMS IntelliSense是一个纯粹的废话，有时行得通，有时却行不通.我会去寻找第三方工具.

From my personal experience, SSMS IntelliSense is a pure crap, sometimes it works, sometimes it doesn't. I'd go for third party tools.

如果您愿意花现金，我建议 dbForge SQL Complete ，效果不如SQL提示，但是做得不错.

If you're willing to spend your cash, I'd recommend Redgate SQL Prompt.
If you need a free product, try dbForge SQL Complete, it's not as good as SQL Prompt, but does a decent job.

这篇关于Intellisense在SQL Server 2014中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！