我创建sql触发器，但它显示错误 [英] i create sql trigger but it show error

问题描述

请检查我的触发器代码

please check my trigger code

SET @priority = (SELECT dbo.Jobs.ProcessStatus FROM dbo.Jobs WHERE dbo.Jobs.ProcessStatus = @NotificationTypeID);

        IF(@priority = 1)
        Begin
            SET @NotificationTypeID = 1;
            SET @NotificationType='Normal';
            End
        ELSE
            IF(@priority = 2)
            Begin
            SET @NotificationTypeID = 2;
            SET @NotificationType='Critical';
        END

推荐答案

如果你愿意的话会有所帮助发布您遇到的错误但是...



根据您提供的代码，您很可能遇到查询尝试将多行提取到单个变量中的问题。这一个

It would really help if you would post the error you encountered but...

Based on the code you provided you most likely encounter a problem that your query tries to fetch multiple rows into a single variable. This one

SET @priority = (SELECT dbo.Jobs.ProcessStatus FROM dbo.Jobs WHERE dbo.Jobs.ProcessStatus = @NotificationTypeID);

如果这是真的，你几乎没有选择：

- 确保通过修改条件只选择一行

- 使用游标创建循环，处理所有返回的行

- 而不是游标使用单个语句在数据库中进行修改（如果你正在修改数据）



如果错误有所不同，请发布完整描述。

If that's true you have few choices:
- ensure that you select only one row by modifying the conditions
- create a loop using a cursor where you handle all the returned rows
- instead of cursor use a single statement to make modifications in the database (if you're modifying the data)

If the error is something different, please post the full description.

这篇关于我创建sql触发器，但它显示错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！