错误：名称“EmpBenefitDeductID”在这种情况下是不允许的。有效表达式是常量，常量表达式和（在某些上下文中）变量。不允许使用列名。 [英] error : The name "EmpBenefitDeductID" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

问题描述

CREATE PROCEDURE InsertEmployeeBenefitsDeducts
(
@BranchID bigint,
@EmployeeID bigint,
@BenefitDeductionID bigint,
@AffectOnLeave bit,
@Amount decimal(18,4),
@CreatedUserID bigint,
@CreatedDate datetime,
@ModifiedUserID bigint,
@ModifiedDate datetime
)
AS
DECLARE @EmpBenefitDeductID as  bigint
SELECT @EmpBenefitDeductID=ISNULL(MAX(EmployeeBenefitsDeducts.EmpBenefitDeductID),0)FROM EmployeeBenefitsDeducts
SET @EmpBenefitDeductID=@EmpBenefitDeductID+1


INSERT INTO EmployeeBenefitsDeducts VALUES
(
EmpBenefitDeductID,
BranchID,
EmployeeID,
BenefitDeductionID,
AffectOnLeave,
Amount,
CreatedUserID,
CreatedDate,
ModifiedUserID,
ModifiedDate
)
VALUES
(
@EmpBenefitDeductID
@BranchID ,
@EmployeeID ,
@BenefitDeductionID ,
@AffectOnLeave ,
@Amount (18,4),
@CreatedUserID ,
@CreatedDate ,
@ModifiedUserID ,
@ModifiedDate 
)
SELECT @EmpBenefitDeductID

推荐答案

尝试使用 BEGIN ... END 代码块;）

Try with BEGIN ... END code block ;)

CREATE PROCEDURE InsertEmployeeBenefitsDeducts
(
@BranchID bigint,
@EmployeeID bigint,
@BenefitDeductionID bigint,
@AffectOnLeave bit,
@Amount decimal(18,4),
@CreatedUserID bigint,
@CreatedDate datetime,
@ModifiedUserID bigint,
@ModifiedDate datetime
)
AS
BEGIN
DECLARE @EmpBenefitDeductID as  bigint
SELECT @EmpBenefitDeductID=ISNULL(MAX(EmployeeBenefitsDeducts.EmpBenefitDeductID),0)FROM EmployeeBenefitsDeducts
SET @EmpBenefitDeductID=@EmpBenefitDeductID+1
 

INSERT INTO EmployeeBenefitsDeducts (EmpBenefitDeductID, BranchID, EmployeeID, BenefitDeductionID, AffectOnLeave, Amount, CreatedUserID, CreatedDate, ModifiedUserID, ModifiedDate)
VALUES (@EmpBenefitDeductID, @BranchID, @EmployeeID , @BenefitDeductionID , @AffectOnLeave , @Amount , @CreatedUserID , @CreatedDate , @ModifiedUserID , @ModifiedDate)

SELECT @EmpBenefitDeductID AS EmpBenefitDeductID
END

这篇关于错误：名称“EmpBenefitDeductID”在这种情况下是不允许的。有效表达式是常量，常量表达式和（在某些上下文中）变量。不允许使用列名。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！