操作数类型冲突:日期与INT不兼容，在打印语句中具有变量

Question

我正在尝试在MS SQL Server中创建一个触发器，但是我不断收到'操作数类型clash：date与int'错误不兼容。我认为错误来自我的印刷语句，但我在SQL中没有足够的文章来知道如何克服这个问题。

ALTER TRIGGER utrInsteadUpdateTblMembership
ON tblMembership INSTEAD OF UPDATE
AS
BEGIN
    DECLARE @newPayDate date, @prevPayDate Date, @prevMemberNumber int
    Select @newPayDate = MembershipFeePaidDate FROM inserted
    Select @prevPayDate = MembershipFeePaidDate FROM deleted
    Select @prevMemberNumber = MembershipID FROM deleted 

    IF @prevPayDate IS NOT NULL AND @prevPayDate > @newPayDate
        BEGIN 
            UPDATE tblMembership 
                SET MembershipFeePaidDate = @newPayDate 
                WHERE @prevMemberNumber = MembershipID 
            UPDATE tblMembership 
                SET isCurrentMember = 1
                WHERE @prevMemberNumber = MembershipID 
            PRINT 'Membership Number ' + @prevMemberNumber + ':' + ' payment date is ' + @newPayDate + ';' + ' prior payment date is ' + @prevPayDate
        END
    ELSE
        BEGIN
            PRINT 'Membership Number ' + @prevMemberNumber + ':' + ' new payment date ' + @newPayDate + ' is earlier than prior payment date ' + @newPayDate +';' + 'No change made' 
        END
END

Answer 1

是因为它像加法与串联一样解释它。动态SQL

也是如此

 PRINT 'Membership Number ' + cast(@prevMemberNumber as char(8)) + ':' + ' new payment date ' + convert(varchar(10),@newPayDate,101) + ' is earlier than prior payment date ' + convert(varchar(10),@newPayDate,101) +';' + 'No change made'