自定义规则高级操作 请不要乱尝试

CREATE PROCEDURE CheckTxSerialNumber
    @lotId nvarchar(100),
    @stationId nvarchar(100),
    @routeStepId nvarchar(100),
    @userId nvarchar(100),
    @serialNumber nvarchar(200)
AS
BEGIN
    declare @serialCount int
    select @serialCount = count(SERIAL_NUMBER) from QS_SERIAL_NUMBERS where SERIAL_NUMBER = @serialNumber
    if @serialCount >= 1
    begin
        select 1 errorcode,'条码' + @serialNumber + '已存在'
        return;
    end

    select 0 errorcode
END
GO