且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在主机服务器上找不到表0错误

更新时间:2023-11-21 19:16:28

好像查询未返回任何内容.访问任何数据集之前,请先检查该数据集是否完全包含任何表.

调试代码并检查数据集是否返回任何值.
Looks like the query did not return anything. Check first if the the dataset contains any tables at all before accessing any.

debug your code and check if dataset return any value.


这是解决此错误的方法
This is the solution for this error
ALTER PROCEDURE [dbo].[GetInvoceTaxpurchase]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 
        -- Insert statements for procedure here
	SELECT max(InvoiceNo), max(BookNo)
        FROM BookInvoiceTax
END