获取错误MS Sql2008： - 消息137，级别15，状态2，行13必须声明标量变量。请帮忙解决我的问题， [英] Getting Error MS Sql2008:- Msg 137, Level 15, State 2, Line 13 Must declare the scalar variable . Please help to solve my problem,

问题描述

// My Query is..
SELECT        Division.DivisionName, FeesPaymentDetails.FullName, FeesPaymentDetails.RegistrationNumber, FeesPaymentDetails.TotalFeesToBePaidWithoutDiscount, 

FeesPaymentDetails.TotalFeesToBePaid, 
                         FeesPaymentDetails.BalanceFees, FeesPaymentDetails.FeesPaid, FeesPaymentDetails.TotalDiscount, FeeStructureType.FeeType, FeeStructureType.FeeAmount, 

STANDARD.StandardName, 
                         GroupName.GroupName, FeesInstallment.FeesInstallmentDetails, FeesInstallment.FeesInstallmentAmount, FeesInstallment.FeesInstallmentDate, 

FeesDiscount.FeesDiscountAmount, 
                         FeesDiscount.FeesDiscountDate, FeeStructureYear.AcademicYear
FROM            Division LEFT OUTER JOIN
                         FeesPaymentDetails ON Division.DivisionId = FeesPaymentDetails.DivisionId LEFT OUTER JOIN
                         STANDARD ON FeesPaymentDetails.StandardId = STANDARD.StandardId LEFT OUTER JOIN
                         FeeStructureType ON STANDARD.StandardId = FeeStructureType.StandardId LEFT OUTER JOIN
                         GroupName ON FeesPaymentDetails.GroupId = GroupName.GroupId AND FeeStructureType.GroupId = GroupName.GroupId LEFT OUTER JOIN
                         FeesInstallment ON FeesPaymentDetails.FeesPaymentDetailsId = FeesInstallment.FeesPaymentDetailsId LEFT OUTER JOIN
                         FeesDiscount ON FeesPaymentDetails.FeesPaymentDetailsId = FeesDiscount.FeesPaymentDetailsId LEFT OUTER JOIN
                         FeeStructureYear ON FeesPaymentDetails.FeesStructureYearId = FeeStructureYear.FeeStructureYearId AND FeeStructureType.FeeStructureYearId = 

FeeStructureYear.FeeStructureYearId
WHERE        (FeesPaymentDetails.RegistrationNumber = @RegistrationNumber) AND (FeesInstallment.FeesInstallmentDate = @FeesInstallmentDate) AND 

(FeeStructureYear.AcademicYear = @AcademicYear)

推荐答案

SQL中有3个变量： @RegistrationNumber ， @FeesInstallmentDate 和 @AcademicYear ，因此至少其中一个未被声明（或者有一个您的存储过程中的错误名称（假设您的SQL只是SP的一部分）！

You have 3 variables in your SQL: @RegistrationNumber, @FeesInstallmentDate and @AcademicYear, so at least one of them is not declared (or has a wrong name) in your stored procedure (supposing that your SQL is only a part from a SP)!

这篇关于获取错误MS Sql2008： - 消息137，级别15，状态2，行13必须声明标量变量。请帮忙解决我的问题，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！