Incorrect SQL procedure lin_WriteCastleTax
Issue #11
new
В паке от смели процедура принимает всего 2 параметра, а в с1 china 5.
packet036_RequestWriteCastleTax
CREATE PROCEDURE [DBO].[lin_WriteCastleTax]
(
@nIsCastle int,
@tax_type int,
@tax_rate int,
@to_change int,
@residence_id int
)
AS
SET NOCOUNT ON
IF(@nIsCastle = 1)
BEGIN
IF (@tax_type = 2)
UPDATE castle SET tax_child_rate = @tax_rate, tax_child_rate_to_change = @to_change WHERE id = @residence_id
ELSE IF (@tax_type = 1)
UPDATE castle SET tax_rate = @tax_rate, tax_rate_to_change = @to_change WHERE id = @residence_id
ELSE
RAISERROR ('tax type is invalid. castle cannot save type[%d] id and castle id[%d].', 16, 1, @tax_type, @residence_id )
END
ELSE IF(@nIsCastle = 0)
BEGIN
IF (@tax_type = 2)
BEGIN
UPDATE agit SET tax_child_rate = @tax_rate, tax_child_rate_to_change = @to_change WHERE id = @residence_id
END
ELSE IF (@tax_type = 1)
UPDATE agit SET tax_rate = @tax_rate, tax_rate_to_change = @to_change WHERE id = @residence_id
ELSE
RAISERROR ('tax type is invalid. agit cannot save type[%d] id and agit id[%d].', 16, 1, @tax_type, @residence_id )
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
в паке смели есть всё нормально: