也许您对如何解决我的问题有一些想法？谢谢 09/04/2024 20:50:54.232，[ErrSQL] 状态：42000 错误：4121 消息：[Microsoft][ODBC SQL Server 驱动程序][SQL Server] 找不到任一列 \'...

也许您知道解决我的问题的方法？谢谢

2024 年 9 月 4 日 20:50:54.232，[ErrSQL] 状态：42000 错误：4121 消息：[Microsoft][ODBC SQL Server 驱动程序][SQL Server] 找不到列\'dbo\'或用户定义函数或聚合\'dbo.SetBitFlag\'，或者名称不明确。

代码：

(
    @booking_time INT,
    @job_type INT,
    @job_value INT
)
AS
    SET NOCOUNT ON

    IF NOT EXISTS(SELECT * FROM regular_db_job 
                  WHERE booking_time = @booking_time 
                    AND job_type = @job_type 
                    AND job_value = @job_value)
    BEGIN
        IF @job_type = 1
        BEGIN
            EXEC dbo.lin_DeleteItemByType '123456789!', '', '', @job_value
        
            INSERT INTO regular_db_job 
            VALUES (@booking_time, @job_type, @job_value, GETDATE())
        END
        ELSE IF @job_type = 2
        BEGIN
            DELETE FROM user_NewActiveSkill 
            WHERE skill_id = @job_value
        
            INSERT INTO regular_db_job 
            VALUES (@booking_time, @job_type, @job_value, GETDATE())
        END
        ELSE IF @job_type = 3
        BEGIN
            DECLARE @questID INT
        
            DELETE FROM user_quest 
            WHERE quest_no = @job_value
        
            SET @questID = @job_value
        
            IF @questID > 10000
            BEGIN
                SET @questID = @questID - 10000
            END
        
            IF @job_value <= 255 OR @job_value > 10000
            BEGIN
                UPDATE user_data 
                SET quest_flag = dbo.SetBitFlag(quest_flag, @questID, 0)
            END
        
            INSERT INTO regular_db_job 
            VALUES (@booking_time, @job_type, @job_value, GETDATE())
        END
        ELSE IF @job_type = 4
        BEGIN
            DELETE FROM UI_event_count 
            WHERE log_date < @job_value
         
            INSERT INTO regular_db_job 
            VALUES (@booking_time, @job_type, @job_value, GETDATE())
        END
    END

谷歌蚂蚁在某处