无效的对象名称"dbo.CompleteTrainings". [英] Invalid object name 'dbo.CompleteTrainings'.

问题描述

我正在使用SQL  View来创建在线报告，但出现以下错误.我检查了整个程序代码，但找不到此名称，因此我假设命名约定不会成为问题.有人可以帮我吗，我真的需要尽快解决

I am using SQL View to create an online report but getting below error. I checked whole program code but could not find this name so I am assuming naming convention can not be the issue. Can someone help me I really need to fix it ASAP

Line 42:                          select a
Line 43:                                 );
Line 44:                 totalRecord = v.Count();
Line 45:                 v = v.OrderBy(sort + " " + sortdir);
Line 46:                 if (pageSize > 110)

推荐答案

似乎您的程序调用或生成了一些SQL脚本来尝试访问 "CompleteTrainings" 表或视图，该表或视图不存在.

Seems that your program invokes or generates some SQL scripts that try to access the ‘CompleteTrainings’ table or view, which does not exist.

也许会显示有关此部分代码的更多详细信息.或搜索磁盘上的所有文件以找到对文件的引用 完整培训" .

Maybe show more details about this portion of code. Or search all of the files on disk to find the references to ‘CompleteTrainings’.

这篇关于无效的对象名称"dbo.CompleteTrainings".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！