SQL Server 2012中的表别名问题
问题描述：
我正在使用sql server 2012 server.My问题是，当我编写查询时，表别名不会自动获取列名。
有人可以帮我解决一下......谢谢!!
我尝试了什么：
从部门a中选择*，其中a.departmentid .....这里的离开列必须在我写一个时自动获取。在我的情况下不会发生这种情况。
我在sql server2012中也启用了intellisense。但它仍无法正常工作。
I am using sql server 2012 server.My issue is that Table aliase is not fetching columns names automatically when i am writing queries.
Could someone help me to sort it out..Thanks!!
What I have tried:
Select * from department a where a.departmentid .....here departmentid column has to be fetch automatically when i write a. This is not happening in my case.
I have also enabled intellisense in sql server2012 .But still its not working.
答
我假设你在讨论intellisence
几个原因。
1：页面上有一个错误，不允许分析整个脚本
2：intellisence缓存没有自更改以来已更新（ctrl + shift + r to force）
3：第三方智能应用程序已过期
4：已关闭。检查链接
配置IntelliSense（SQL Server Management Studio）| Microsoft Docs [ ^ ]
希望有所帮助：）
I assume your talking about intellisence
Couple of reasons for this.
1: There is an error on the page that is not allowing the whole script to be analysed
2: The intellisence cache has not been updated since a change was made (ctrl+shift+r to force)
3: Third party intellisence app has expired
4: It's turned off. check the link
Configure IntelliSense (SQL Server Management Studio) | Microsoft Docs[^]
Hope that helps :)